MySQL query response makes no sense.

Results 1 to 3 of 3
  1. #1
    Member Luicy is offline
    MemberRank
    Feb 2018 Join Date
    49Posts

    MySQL query response makes no sense.

    So I'm trying to update all rows that's got a page_id column assigned to X, however it makes no change and tells me "0 rows affected". The query is fine, I even tried using a SELECT; query directly after to make sure the page_id is right, but it's working fine.

    UPDATE catalog_items SET offer_active = 1 WHERE page_id = 912378;
    SELECT * FROM catalog_items WHERE page_id = 912378;


  2. #2
    Death from above! The General is offline
    DeveloperRank
    Aug 2011 Join Date
    9,246Posts

    Re: MySQL query response makes no sense.

    offer_active = '1' ? Use single quotes around the 1
    Discord: TheGeneral#0063
    Join the Arcturus Discord server: https://discord.gg/eDr7FKQ (You can ask help here regarding Arcturus :love)

  3. #3
    Member Luicy is offline
    MemberRank
    Feb 2018 Join Date
    49Posts

    Re: MySQL query response makes no sense.

    Quote Originally Posted by The General View Post
    offer_active = '1' ? Use single quotes around the 1
    Ah yes, appreciate the help so quickly. (y)



Advertisement