I have a mysql database that has three tables. customers, orders, and order details. I want my customer to logon using a username and password that will show a list of his current orders. From there I want to be able to click on any given order and see the order details.
Any help would be great!
Thanks
Stick
0
Newbie Poster
Recommended Answers
Jump to PostFollowing the example cjgraphix gave you:
$get_orders = mysql_query("SELECT order_id, ordername FROM orders WHERE member id = '$member_id' ORDER BY order_id"); while($myorder = mysql_fetch_array($get_orders)){ echo "<a href='viewdetail.php?id=" . $myorder['order_id'] . "'>".$myorder['order_id']."</a> " . $myorder['order_name'] . "<br/>"; }
then having a viewdetail.php file (check how the link is …
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.