Query for +1 on page load?

Discussion in 'PHP' started by nickharper, Oct 15, 2007.

0
  1. #1
    Hi,

    What query would I use to add 1 to a field on page load?

    Thanks
     
    nickharper, Oct 15, 2007 IP
  2. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #2
    You can do something like:
    
mysql_query("
    UPDATE table_name
    SET field_name = field_name + 1
    WHERE foo = 'bar'
    LIMIT 1
") OR die(mysql_error());
    PHP:
     
    nico_swd, Oct 15, 2007 IP
  3. nickharper

    nickharper Active Member

    Messages:
    732
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    75
    #3
    Thankyou for your help. That has worked a treat :)
     
    nickharper, Oct 15, 2007 IP