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
[EMAIL PROTECTED]

T: (604) 872-6915
F: (425) 732-1547


-- 
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]

Reply via email to