RE: [PHP-DB] Please help
| From: | Gary Every | Date: | Wed, 08 Sep 2004 20:39:43 +0000 |
| Subject: | RE: [PHP-DB] Please help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36123@lists.php.net to get a copy of this message | ||
What exactly is in the $sql and $sql_ext??
Try to put it into a variable so you can print out what you're sending
to the DB
Such as:
$query = $sql . " " . $sql_ext . " limit 0,1";
Echo $query . "<BR>";
If your $sql and $sql_ext combine to make a valid sql query, the " " is
just putting a space inside the query, and it is valid
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
-----Original Message-----
From: Stuart Felenstein [mailto:stuart4m@yahoo.com]
Sent: Wednesday, September 08, 2004 2:29 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Please help
I'm using a product called dbqwiksite pro. PHP
generator for PHP - MySQL
The code seems to be working fine except in my search
page where I receive an "invalid query"
$result = mysql_query($sql . " " . $sql_ext . " limit
0,1")
or die("Invalid query");
This is the place I where the code is taking the die
path.
I'm guessing something belongs between the quotation
marks , just not sure.
Anyone ?
Thank you
Stuart
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php