RE: [PHP] MySQL Query not working?

[Peter Houchin - SunRentals Australia]

change it to

$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' ";

also if a MySQL query doesn't work I always try it on the command line :)


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

-----Original Message-----
From: Laurie Landry [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 9:23 AM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL Query not working?


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]