Re: mysql: UPDATE statment
| From: | Mark Charette | Date: | Fri, 11 May 2001 02:33:32 +0000 |
| Subject: | Re: mysql: UPDATE statment | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-52385@lists.php.net to get a copy of this message | ||
Reading the MySQL manual on the UPDATE statement (my, what a concept -
actually looking at a manual, especially when you have no clue ...) would
show you that your statement is invalid and why. Something about using a
"set column-name=data" rather than an invalid "values()" statement.
Mark C.
----- Original Message -----
From: <PeterOblivion@aol.com>
To: <php-general@lists.php.net>
Sent: Thursday, May 10, 2001 9:40 PM
Subject: [PHP] mysql: UPDATE statment
> why isnt this working
>
> i need to get 5 values updated in a table called 'user_polls'
>
> how do I do this?
> i have
>
> UPDATE user_polls WHERE id = '$id' VALUES($1, $2..... and so on
>
> im getting a SQL error
>
> anyone?
>
> - Peter
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>