TGM Posted May 4, 2009 Share Posted May 4, 2009 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.. Quote Link to comment Share on other sites More sharing options...
Ken2k7 Posted May 4, 2009 Share Posted May 4, 2009 Wrong forum. Anyways, can you post the query? Quote Link to comment Share on other sites More sharing options...
Maq Posted May 4, 2009 Share Posted May 4, 2009 You would need a date column in order to do that, how else can you know what the order is supposed to be? Anyway, it would be something like: ORDER BY date_field DESC Moving to MySQL Help section... Quote Link to comment Share on other sites More sharing options...
TGM Posted May 4, 2009 Author Share Posted May 4, 2009 You would need a date column in order to do that, how else can you know what the order is supposed to be? Anyway, it would be something like: ORDER BY date_field DESC Moving to MySQL Help section... Well I was thinking the Id would uniquely represent an order BUT i have it as auto-increment. I think the date wouldn't be a wise idea because what on a certain day many Orders are made. What I want to display is the last order made. Display the order of only one customer not the order of many customers with in a day. my query is as fallows:: <?php $hostname = "localhost"; $db_user = "root"; $db_password = ""; $database = "users"; $db = mysql_connect($hostname, $db_user, $db_password); mysql_select_db($database,$db); ?> <html > <head></head> <body> <div id="body"><div id="content"><div class="i"> <div align="center"><em>Your Order Is:</em></div> <HR WIDTH="75%" SIZE="3" NOSHADE><br /> <?php [color=red]$result = mysql_query("SELECT * FROM orders");[/color] 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); ?> </body></html> Quote Link to comment Share on other sites More sharing options...
fenway Posted May 4, 2009 Share Posted May 4, 2009 Well I was thinking the Id would uniquely represent an order BUT i have it as auto-increment. I think the date wouldn't be a wise idea because what on a certain day many Orders are made. What I want to display is the last order made. Display the order of only one customer not the order of many customers with in a day. You can't find the "last" order unless you store temporal data somehow. Quote Link to comment Share on other sites More sharing options...
Maq Posted May 4, 2009 Share Posted May 4, 2009 I mean, the last one ordered would presumably be the last one inserted. But this way wouldn't be reliable. You would have to do something like: SELECT * FROM orders ORDER BY id DESC LIMIT 1 You need to have a 'date' column in your table to have queries like this. NOTE - Color tags are recognized inside code tags. Quote Link to comment Share on other sites More sharing options...
TGM Posted May 4, 2009 Author Share Posted May 4, 2009 I mean, the last one ordered would presumably be the last one inserted. But this way wouldn't be reliable. You would have to do something like: SELECT * FROM orders ORDER BY id DESC LIMIT 1 You need to have a 'date' column in your table to have queries like this. NOTE - Color tags are recognized inside code tags. THanks Maq it works and sorry for posting it on this section...i accidentally posted it on this section..i thought it was the php help section!..mah bad! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.