Re: [PHP] mysql: UPDATE statment

[Christian Dechery]

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:

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


-- 
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] mysql: UPDATE statment

[PeterOblivion]

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]

RE: [PHP] mysql: UPDATE statment

[Peter Houchin - SunRentals Australia]

UPDATE user_polls SET value='$value',value1='$value1',etc for more values WHERE id=$id 
 

Peter Houchin
[EMAIL PROTECTED]
=
 _  __   /\
/_/_/_\/  |_/  \
   /_/_/___  __  __   __  / \
   \_/_/_\  /_/ /_/ /_/  /_/  \   _ /
 ___\_\_\/ /_/_/_/ /_//\/_/\_/ \/\_/
 \_//_/_/ /_/_/_/ /_/ \/_/v
    
/_/_/_/_/  /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
   /_/_ _/_/ __  __   __  /_/   __ __
  /_/_/_/_/ /_/_/_/ /_/  /_/ /_/ /_/\_\/_//_/_/_/
 /_/  \_\  /_/ _/  /_//\/_/ /_/ /_/__\_\  /_/___ _\_\_\
/_/\_\/_/_/_/ /_/ \/_/ /_/ /_/\_\/_/_/_//_/_/_/
=
Telephone : (03) 9329 1455  Facsimile : (03) 9329 6755
* We rent the dot in .COM!  **
 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 11:40 AM
To: [EMAIL PROTECTED]
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]

Re: [PHP] mysql: UPDATE statment

[Mark Charette]

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]