Query syntax problem

[Jon12345]

What is wrong with this?

$result = mysql_query("SELECT * FROM products WHERE ProductID=".$filter." AND CategoryID=".$CategoryID);

[kburger]

$result = mysql_query("SELECT * FROM products WHERE ProductID=$filter AND CategoryID=$CategoryID");

or

$result = mysql_query("SELECT * FROM products WHERE ProductID=".$filter." AND CategoryID=".$CategoryID.")";

[wimpers]

$result = mysql_query("SELECT * FROM products WHERE ProductID=".$filter." AND CategoryID=".$CategoryID.")";

If I'm not mistaken this one is wrong. The end has a mistake.
Could you echo the query?

$result = mysql_query("SELECT * FROM products WHERE ProductID='".$filter."' AND CategoryID='".$CategoryID."'");

Should do the trick.

[kburger]

Oops, you're right. My bad.

[dchoksi]

well i think even this should work

$result = mysql_query("SELECT * FROM products WHERE ProductID='$filter' AND CategoryID='$CategoryID')";

[twoeyes]

The last is the best IMO