--- Reçu de VITEUR.BUNTERMA 04 72 96 57 77 30/05/02 08.17 -----
I found this link the other day which may have some interesting examples : http://php.resourceindex.com/Complete_scripts think I saw a Shopping cart section but haven't investigated it yet. Matt --------------------------------------------------------------------------------------- Date: Wed, 29 May 2002 12:06:35 -0500 Subject: RE: Building a Shopping Cart with MySQL [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 ---- 30/05/02 08.17 ---- Envoyé à ------------------------------------------------ -> mysql(a)lists.mysql.com --------------------------------------------------------------------- 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
