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 <[EMAIL PROTECTED]> wrote: > What's contained in $sql and $sql_ext ??? > > > Stuart Felenstein wrote: > > >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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php