Re: SQL statement using criteria

[shailen]

Hi there,

I am using PHP and i can't execute my SQL statement which is as follows:

$query = "SELECT products.brandname
FROM product_subcategory INNER JOIN (product_gencategory INNER JOIN products ON product_gencategory.gencategoryid = products.gencategoryid) ON product_subcategory.subcategoryid = products.subcategoryid
WHERE (((product_gencategory.gencategory)='Stationery') AND ((product_subcategory.subcategory)='Disk'))";
$result = mysql_query($query)
or die("query failed");

Could you please help...

Regards,

Shailen

[Anon]

I'm not sure what you are trying to do with this...

$query = "SELECT brandname FROM products, product_subcategory, product_gencategory
WHERE (((product_gencategory.gencategory)='Stationery') AND ((product_subcategory.subcategory)='Disk'))";
$result = mysql_query($query) or die("query failed");

That's the way I'd write it

Mark