HELP; Is this correct?

[Anon]

Hello;
I am trying to get my dropdown nav boxes to work correctly. I cannot get this query to work. I am trying to get it to select the category based upon the sku and inventory tables actually having a valid quantity greater than 0. Any thoughts on why this is not working?

Shawn

$Query = "SELECT c.ID, c.Name, c.Parent, i.SKU, i.Available, s.ID ";
$Query .= "FROM category c, inventory i, sku s ";
$Query .= "WHERE c.Parent=$root";
$Query .= "AND i.SKU = s.ID";
$Query .= "AND i.Available > 0";

[Anon]

what type of database you use? mysql? postgresql?
maybe you are using reserved words... verify if 'id' is a reserved word.

if it's postgresql, there is an error at where clause:
"... WHERE c.Parent='$root'" .....
you need to put single quotes in strings..
at the end of your query there is another error: you need to put a ; there:
"... AND i.Available > 0;";

if dont works again, tell us what is the error msg..

[Anon]

Actually, you do <i>not</i> need a semicolon at the end
of the sql statement in PostgreSQL. This is a requirement
of their psql command-line utility, but not of the sql engine
itself.

[Anon]

Sorry I should have said I am using MySQL. Running on a Solaris machine and using PHP4 as well.

Shawn

[Anon]

I think icaro's idea to make sure you are putting
single-quotes around the char data is the most
likely thing.