Yeah I didn't notice that.. VALUES must not be there . it should be : set days_member=days_member+1
thanks for pointing that out:) Gurhan -----Original Message----- From: Lokesh Verma [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 5:12 PM To: Gurhan Ozen Subject: Re: [PHP-DB] Update i don't know why that 'VALUES' is there? Lokesh ----- Original Message ----- From: "Gurhan Ozen" <[EMAIL PROTECTED]> To: "Jennifer Downey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 3:28 AM Subject: RE: [PHP-DB] Update > Try it without quotes around days_member and 1. > > Gurhan > > > -----Original Message----- > From: Jennifer Downey [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 04, 2002 4:51 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Update > > > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php