I'm currently writing a shopping cart using PHP 4.0.6 and MySQL 3.23.32. I'm designing the tables and have hit a wall.
I'm think about putting customer info, minus order info, in one table and the order info, linked back to the customer table in another table. What's the best way to handle multiple items purchases? You never know how many items any person may order so how would you structure the order table to accomodate this? Try and somehow get all the items for each purchase into one record, or use a seperate record for each item and somehow link that back to a single order?