MySQL Query not working?

From: Date: Mon, 14 May 2001 23:23:11 +0000
Subject: MySQL Query not working?
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-52764@lists.php.net to get a copy of this message
Hi, I've got this sql setup where $sql = "UPDATE CLASS_ADS SET client_id = \"$client_id\", date = \"$date\", category = \"$category\", title = \"$title\", description = \"$description\", contact_name = \"$contact_name\", contact_number = \"$contact_number\", email = \"$email\", url = \"$url\", WHERE client_id = \"$client_id\" "; and of course the following: $sql_result = mysql_query($sql) or die("Couldn't execute query."); which when I test the page, it tells me it couldn't execute the query. I hope the information above is enough for someone to help me pinpoint where I went wrong. (all the fields in the named table in the database is set accordingly with one thing: the client id number is autogenerated by the database, so I'm not sure if the client_id should be there.) Thanks in advance: Laurie M. Landry <lmlweb> Design & Development www.lmlweb.com lmlweb@lmlweb.com T: (604) 872-6915 F: (425) 732-1547

« previous php.general (#52764) next »