RE: [PHP] mysql: UPDATE statment

UPDATE user_polls SET value='$value',value1='$value1',etc for more values WHERE id=$id Peter Houchin peterh@sunrentals.com.au ========================================================= _____ __ /\ /_/_/_\ / |_/ \ /_/_/_ __ __ __ __ / \ \_/_/_\ /_/ /_/ /_/ /_/ \ _ / ___\_\_\/ /_/_/_/ /_//\/_/ \_/ \/\_/ \_//_/_/ /_/_/_/ /_/ \/_/ v ________ ________________________________________ /_/_/_/_/ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ /_/_ _/_/ ______ __ __ /_/ ____ __ ______ /_/_/_/_/ /_/_/_/ /_/ /_/ /_/ /_/\_\ /_/ /_/_/_/ /_/ \_\ /_/ _/ /_//\/_/ /_/ /_/__\_\ /_/___ _\_\_\ /_/ \_\/_/_/_/ /_/ \/_/ /_/ /_/ \_\/_/_/_//_/_/_/ ========================================================= Telephone : (03) 9329 1455 Facsimile : (03) 9329 6755 ************* We rent the dot in .COM! ************** -----Original Message----- From: PeterOblivion@aol.com [mailto:PeterOblivion@aol.com] Sent: Friday, May 11, 2001 11:40 AM To: php-general@lists.php.net 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