Jump to content


Photo

Auto Update....


  • Please log in to reply
1 reply to this topic

#1 kickassamd

kickassamd
  • Members
  • PipPipPip
  • Advanced Member
  • 102 posts
  • LocationDallas Tx

Posted 26 October 2005 - 05:20 AM

I have a column that is only numbers (starts at 0) that i would like to auto increase by 1 on each access... example

select * from `users` where `username` = 'bob' and `password` = 'bobspass';

i would like to have the record of bobs accessID increase by 1 then the next time he \ she logs in add 1 again... etc etc etc

#2 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 26 October 2005 - 05:29 AM

you cannot do it while selecting... need a separate query to update.
Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users