Items Less Than 10 In Stock
$results = mysql_query("SELECT * FROM products WHERE stock < '10'"); echo "
| Item Code | Name | Detail | Sale Price | In Stock | Order Level | Actions | "; echo "
|---|---|---|---|---|---|---|
| ".$row['product_code']." | ".$row['product_name']. " | " .$row['product_detail']. " | ".$row['product_sale']. " | ".$row['stock']. " | ".$row['order_qty']. " | Delete Edit | "; echo "
";// displaying paginaiton. ?>