RE: [PHP-DB] Update
| From: | Gurhan Ozen | Date: | Mon, 04 Feb 2002 22:40:47 +0000 |
| Subject: | RE: [PHP-DB] Update | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16513@lists.php.net to get a copy of this message | ||
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:lokesh_verma125@hotmail.com]
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" <c-gurhan.ozen@wcom.com>
To: "Jennifer Downey" <gcarlyle2@attbi.com>; <php-db@lists.php.net>
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:gcarlyle2@attbi.com]
> Sent: Monday, February 04, 2002 4:51 PM
> To: php-db@lists.php.net
> 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
>
>