MySQL Query not working?
| From: | Laurie Landry | 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