在PHP中，如何仅选择数量大于0的项目？ [关闭]

Question

$quantity=$_POST['quantity'];

do{

 $request="SELECT id, name, type, price FROM `corro`.`food`";

$result=mysql_query($request);

}while(quantity>0)

Answer 1

Based on your comment I assume it's this:

$quantity=$_POST['quantity'];
$request="SELECT id, name, type, price FROM `corro`.`food` WHERE quantity>0";
$result=mysql_query($request);