2 SQL queries in one line - how?

Question

The following errors,so must be wrong,but what is the correct way to do this:

$query = "SELECT * FROM tblProducts WHERE ProductId ='$SCId' AND SELECT * FROM tblProducts WHERE Cat ='$CatType' AND Type ='$TypeType'";

$rsPrimary = mysql_query($query) or die ("Query '$query' failed with error message: \"" . mysql_error () . '"'); $num=mysql_numrows($rsPrimary); mysql_close();

Answer 1

The 'AND' statement in your WHERE clause is expecting a condition on its right hand side. You cannot place a SELECT query there.

Answer 2

    SELECT * FROM tblProducts WHERE ProductId ='$SCId' 
                                  OR (Cat ='$CatType' AND Type ='$TypeType')

Answer 3

Looks to me like what you really want is:

select * from tblProducts
where ProductId ='$SCId'
or ( Cat ='$CatType' AND Type ='$TypeType' )

Answer 4

The answers already given are correct for your query, however if, in the future you want to append the results of two or more select statements together you should take a look at UNION or UNION ALL. So your original query would have worked if you replaced your first and with UNION.
UNION removes duplicates from the results, UNION ALL doesn't and is therefore faster.