MySQL query response makes no sense.

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

    MySQL query response makes no sense.


    RaGEZONE Recommends

    RaGEZONE Recommends

    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
    The OmegaRank
    Aug 2011 Join Date
    9,040Posts

    Re: MySQL query response makes no sense.

    offer_active = '1' ? Use single quotes around the 1
    If you are using Arcturus, contact me
    Skype: wesley.jabbo
    Discord: TheGeneral#0063

  3. #3
    Registered Luicy is offline
    MemberRank
    Feb 2018 Join Date
    18Posts

    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