You might find this article helpful Building an E-Commerce Site Part 1: Building a Product Catalog http://www.devshed.com/Server_Side/PHP/Commerce/Commerce1/page1.html
olinux --- Jay Blanchard <[EMAIL PROTECTED]> wrote: > [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 > __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.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
