RE: [PHP] MySQL Query not working?
| From: | Peter Houchin - SunRentals Australia | Date: | Mon, 14 May 2001 23:46:57 +0000 |
| Subject: | RE: [PHP] MySQL Query not working? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-52766@lists.php.net to get a copy of this message | ||
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
peterh@sunrentals.com.au
=========================================================
_____ __ /\
/_/_/_\ / |_/ \
/_/_/_ __ __ __ __ / \
\_/_/_\ /_/ /_/ /_/ /_/ \ _ /
___\_\_\/ /_/_/_/ /_//\/_/ \_/ \/\_/
\_//_/_/ /_/_/_/ /_/ \/_/ v
________ ________________________________________
/_/_/_/_/ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
/_/_ _/_/ ______ __ __ /_/ ____ __ ______
/_/_/_/_/ /_/_/_/ /_/ /_/ /_/ /_/\_\ /_/ /_/_/_/
/_/ \_\ /_/ _/ /_//\/_/ /_/ /_/__\_\ /_/___ _\_\_\
/_/ \_\/_/_/_/ /_/ \/_/ /_/ /_/ \_\/_/_/_//_/_/_/
=========================================================
Telephone : (03) 9329 1455 Facsimile : (03) 9329 6755
************* We rent the dot in .COM! **************
-----Original Message-----
From: Laurie Landry [mailto:lmlweb@lmlweb.com]
Sent: Tuesday, May 15, 2001 9:23 AM
To: php-general@lists.php.net
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
lmlweb@lmlweb.com
T: (604) 872-6915
F: (425) 732-1547
--
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