Mysql display only if result bigger than 0 : <p>I am running the following query to search products in MySQL, it display everything but I need it to display only the products with more than 0 ( at least 1) in  stock</p>

<pre><code>    $result=mysqli_query($datacenter,"
SELECT * FROM productos 
WHERE codigo like '%$terminos%' 
or sku like '%$terminos%' 
or producto like '%$terminos%' 
or marca like '%$terminos%' 
or modelo like '%$terminos%' 
AND cantidad &gt; 0 
ORDER BY `$orden` 
$emplazamiento 
limit $visualizar");
</code></pre>

<p>The problem is that it display even those with 0 in stock ... Any idea why?</p>
