kickassamd Posted October 26, 2005 Share Posted October 26, 2005 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 Link to comment https://forums.phpfreaks.com/topic/2735-auto-update/ Share on other sites More sharing options...
ryanlwh Posted October 26, 2005 Share Posted October 26, 2005 you cannot do it while selecting... need a separate query to update. Link to comment https://forums.phpfreaks.com/topic/2735-auto-update/#findComment-9147 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.