At 21:40 10/5/2001 -0400, [EMAIL PROTECTED] 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 on
your statement is incorrect... the correct UPDATE syntax is:
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.
---
UPDATE user_polls SET value='$value',value1='$value1',etc for more values WHERE id=$id
Peter Houchin
[EMAIL PROTECTED]
=
_ __ /\
/_/_/_\/ |_/ \
/_/_/_
3 matches
Mail list logo