why doesn't this work?

[viveleroi0]

SELECT * FROM Products WHERE ProdCat=\"$CatSelect\" LEFT JOIN Hold ON Products.ID = Hold.HoldID WHERE Hold.HoldID IS NULL ORDER BY Products.ID

[viveleroi0]

I got everything to work fine, but when I add the WHERE PRODCAT=\"$CatSelect\" part in, it won't work

[Shadeless]

try WHERE ProdCat = '%".$CatSelect."%'"

[viveleroi0]

there where prodcat statement works fine on its own, the rest works fine on its own, but when the two are added together I get an sql query error. It seems I am adding the two together incorrectly!

[viveleroi0]

I think I figured it out... I had to put there WHERE ProdCat statement after the where hold.id is null statement, before the order by statement, it WAS just how it was worded.