Why? There's absolutely no point -- record the date a person became a member and calculate the number of days from that.
In addition, what happens when you fail to run the update routine? Or someone runs it twice? Or it half runs, then dies because the database has gotten so large that the script times out? Who is going to keep track of when it was run? What check value scheme will you have in place to make certain none of this happens? What you are planning to do is bad practice. Please reconsider. Regards - Miles Thompson At 01:51 PM 2/4/2002 -0800, Jennifer Downey wrote: >Hi, > >I am having problems with this code. I want to update a members number of >days they have been a member can anyone help? > >$query["days"]=("UPDATE users set days_member VALUES = ('days_member' + >'1')); >$result=mysql_query($query["days"]); > >Thanks in advance >JD > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php