Newbie, easy question.

[Scorpion]

Hi all, great forum.

Once a page on my website has loaded my code retrieves the value from a field called logins from my Mysql database.
I am unsure how i can increment the value by one and then re-save the information back to the database.

Any help would be gratefully received.

Thanks

Tony

[Jay]

Update table set value = (value+1)

[Scorpion]

ok, i dunno what i'm doing wrong but the code does not seem to do it.

The table is called DF1 the field i wish to increase is called Logins, the connection has allready been made to the db and retrieved all the values, the Logins field is an Int(11) default is 0, not null.
Which of the following is correct:
Update DF1 set $Logins = ($Logins+1)
Update table set $Logins = ($Logins+1)
or are neither right, lol, which is obviously the case or it would have worked.

Thx