Re: mysql: UPDATE statment
| From: | Christian Dechery | Date: | Fri, 11 May 2001 22:40:25 +0000 |
| Subject: | Re: mysql: UPDATE statment | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-52522@lists.php.net to get a copy of this message | ||
At 21:40 10/5/2001 -0400, PeterOblivion@aol.com wrote:
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 onyour statement is incorrect... the correct UPDATE syntax is: UPDATE user_polls set field='value', field2='value2', field3=value3 where id=$id; hope it helps... ____________________________ . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer