Newbie, easy question.

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

User avatar
Scorpion
New php-forum User
New php-forum User
Posts: 7
Joined: Mon Oct 21, 2002 3:02 pm
Location: England
Contact:

Newbie, easy question.

Postby Scorpion » Mon Oct 21, 2002 3:07 pm

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

Postby Jay » Tue Oct 22, 2002 12:52 am

Update table set value = (value+1)

User avatar
Scorpion
New php-forum User
New php-forum User
Posts: 7
Joined: Mon Oct 21, 2002 3:02 pm
Location: England
Contact:

Postby Scorpion » Thu Nov 07, 2002 3:03 pm

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


Return to “PHP coding => General”

Who is online

Users browsing this forum: Bing [Bot], landi and 2 guests