[SOLVED] Display the Result in an HTML Table

[TGM]

 

im working on a simple restaurant db..I have an order page where you select the food item, quantity and show the price. When you click on Submit button it directs you to the another page where it should display the food you order and the bill...

 

On my order Table it has (id, category, item, price, amount)the Id is my primary key and auto-increments.

 

I have a query that display the item and the price on a html table BUT its displays ALL orders made AND NOT THE RECENT ORDER MADE..my problem is how to display that specific order..

 

<?php
$result = mysql_query("SELECT * FROM orders");

echo "<table border='1'>
<tr>
<th>Item</th>
<th>Price</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['item'] . "</td>";
  echo "<td>" . $row['price'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
mysql_close($db);
?>

[premiso]

$result = mysql_query("SELECT * FROM orders ORDER BY date DESC LIMIT 5");// retrieve 5 rows ordered by date. 

 

Change the limit to be how many rows you want to return.

[TGM]

$result = mysql_query("SELECT * FROM orders ORDER BY date DESC LIMIT 5");// retrieve 5 rows ordered by date. 

 

Change the limit to be how many rows you want to return.

 

THANX a lot premiso..it work. im new at mysql and php!!tnx very much!!