[snip] Is it possible to create your own shopping cart program with just mySQL and PHP? [/snip]
Yep. [snip] 1) I am trying to build my own shopping cart. When building an orders database, is it possible to make room for an infinite number of items in the order? [/snip] Ideally you should have tables for customer, order, products. Any basic SQL book uses this example to demonstrate examples. [snip] 2) The items we sell require a many to many relationship. I have not been able to find any information about many-many relationships in mySQL. Even when I was using access, I knew how to relate the tables using a junction table, but damned if I could figure out how to enter information easily like that. [/snip] While MySQL has some limitations dependent upon the version you are using most SQL related queries will work just as they did in Access. HTH! Jay --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
