Re: Please help
| From: | Philip Thompson | Date: | Fri, 10 Sep 2004 14:03:45 +0000 |
| Subject: | Re: Please help | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36142@lists.php.net to get a copy of this message | ||
I think everyone knows that $sql is a statement. But what people are asking is: what is that statement?! Because if there are "incorrect" characters or 's in that statement, then that can break your code/statement.
~Philip
On Sep 9, 2004, at 5:49 PM, Stuart Felenstein wrote:
Just getting back to this thing. There are 3 files involved, search.php, connections.php and functions.php. I searched through all and couldn't find the meaning of the $sql_ext. $sql is just the sql statement I inserted into the code. Great that I can't get a response from the company. If anyone thinks it would be useful to post the code I will. That is if anyone would want to see and look at it. The weird thing is searching on one table is great. The list (all records) works great. The problem starts when I insert all my joins. Now I've tested and retested the query and I know it's fine. Thank you , Stuart --- Steve Davies <steve@sdconsulting.co.uk> wrote:What's contained in $sql and $sql_ext ??? Stuart Felenstein wrote:-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpI'm using a product called dbqwiksite pro. PHP generator for PHP - MySQL The code seems to be working fine except in mysearchpage where I receive an "invalid query" $result = mysql_query($sql . " " . $sql_ext . "limit0,1") or die("Invalid query"); This is the place I where the code is taking thediepath. I'm guessing something belongs between thequotationmarks , just not sure. Anyone ? Thank you Stuart-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php