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: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to