sum_guy Posted August 3, 2009 Share Posted August 3, 2009 Hi I need to create a table or tables for orders. I need the orders to have a unique order number and have multiple entries. I then need to display these orders with the order number and the multiple entries. Please advise. Quote Link to comment https://forums.phpfreaks.com/topic/168617-orders/ Share on other sites More sharing options...
phpSensei Posted August 3, 2009 Share Posted August 3, 2009 What is your question? Quote Link to comment https://forums.phpfreaks.com/topic/168617-orders/#findComment-889542 Share on other sites More sharing options...
sum_guy Posted August 3, 2009 Author Share Posted August 3, 2009 How do I create a row with a unique id that has multiple entries within one column called items?? Quote Link to comment https://forums.phpfreaks.com/topic/168617-orders/#findComment-889565 Share on other sites More sharing options...
kickstart Posted August 3, 2009 Share Posted August 3, 2009 Hi Have 2 tables. First table for the orders, key being an autonumber integer. Second table for items, key again being an autonumber integer (not that you care too much about the value), a column for a single item, but with another column containing the key for for the order it belongs to. All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/168617-orders/#findComment-889591 Share on other sites More sharing options...
phpSensei Posted August 3, 2009 Share Posted August 3, 2009 How do I create a row with a unique id that has multiple entries within one column called items?? You seriously have to learn how to create mysql tables before coming here for help. Atleast the very basics. Quote Link to comment https://forums.phpfreaks.com/topic/168617-orders/#findComment-889598 Share on other sites More sharing options...
fenway Posted August 3, 2009 Share Posted August 3, 2009 PHPMyAdmin can help you make tables quite easily. Quote Link to comment https://forums.phpfreaks.com/topic/168617-orders/#findComment-889983 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.