#1
  1. A Change of Season
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    3,095
    Rep Power
    220

    How come this query does nothing?


    Hi;

    this gives no error, does nothing either. Not incrementing.

    Code:
     UPDATE sequence_members
    SET    plc_1_number_of_clicks_from_email = plc_1_number_of_clicks_from_email + 1
    WHERE  email = 'someemail@yahoo.com'
    What am I doing wrong?

    Thanks
  2. #2
  3. Forgotten Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    16,180
    Rep Power
    9644
    The WHERE isn't matching. It's that simple.
    Code:
    SELECT email FROM sequence_members WHERE email = 'someemail@yahoo.com'

IMN logo majestic logo threadwatch logo seochat tools logo