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@xxxxxxxxxxxxxxxxxx> 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
