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