1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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