PHP Query Question

[Napster]

I have a php members only RPG site and I am making stores so that they can buy items. Well for each store i use this query code

$result = mysql_query("SELECT * FROM el_storesstock, el_items WHERE el_storesstock.sid='$store' AND el_storesstock.iname= el_items.name");

Now how can I add another statment in there so that is will not select anything from the table called el_storessrock and the row were the columns called stock = 0

[sid]

$result = mysql_query("SELECT *
FROM el_storesstock, el_items
WHERE el_storesstock.sid = '$store'
AND el_storesstock.iname = el_items.name
AND el_storesstock.stock != 0");

rock on man