sql query prob

[Cflax]

$query = 'select * from ob_listings where categoryid=' . $_POST["category"] . ' and  subject like '%$term%' or description like '%$term%'';

 

i want the query to select all from the table ob_listings where categoryid=$_post["category"]

AND then from the items that fit that category

subject like '%$term%' or description like '%$term%''

 

not that familiar with sql statements