mysql join
Posted: Wed Sep 03, 2008 4:04 am
Hi
I have tables producs abd prod_subcat but i can't join the with this code:
I echoed the query and it is:
current error:
Unknown column 'products.productID' in 'where clause'
I have tables producs abd prod_subcat but i can't join the with this code:
I echoed the query and it is:
Code: Select all
SELECT * FROM products pp,prod_subcat ps WHERE (`pp.productID` LIKE
'%40%' OR `productName` LIKE '%40%' OR `productDescription` LIKE '%40%'
OR `productColour` LIKE '%40%' OR `productID` LIKE '%%' OR `productName`
LIKE '%%' OR `productColour` LIKE '%%' ) AND ((ps.subcategoryID='8' AND
ps.productID=pp.productID ) OR (ps.subcategoryID='7' AND
ps.productID=pp.productID ))ORDER BY productID LIMIT 0,50Unknown column 'products.productID' in 'where clause'