Hello, I am not sure why you want to do this. Wouldn't it be better to use calculate the days from the date signed up, rather than through updating your database every day. Try using datediff.
Jeremy 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