Re: grabbing from multiple tables

Thanks Peter. So what is the logic behind foreign keys? Why use them? Thx. Karl Sent from losPhone On Apr 30, 2010, at 5:09 AM, Peter Lind <peter.e.lind@gmail.com> wrote:

On 30 April 2010 12:02, Karl DeSaulniers <karl@designdrumm.com> wrote:

Hello All, I have a product database. In that database there are several tables dealing with individual products. I am wanting to set up an editProduct and a productInfo page. For the bulk info, I am fine. For the product options, I need some guidance. I have 4 tables dealing with the options. Product table = main product table where productID is set Product Options table = table to store product option info. Where productID, optionID and OptionGroupID are stored together per ProductID. Option Groups table = general option groups EG: Size, Color. Where OptionGroupID and OptionGroupName is set. Options table = general options EG: Large, Medium, Small, Red, Blue, etc. Where OptionID and OptionName is set per OptionGroupID. Is there a way for me to call all these tables when adding a product? edit product? view product?

MySQL will only allow you to insert into one table at a time. You can however update several tables at the same time - see http://dev.mysql.com/doc/refman/5.0/en/update.html You can select values form multiple tables with the SELECT syntax: SELECT table1.blah, table2.blah FROM table1, table2 WHERE table1.id = table2.foreign_key; Regards Peter --<hype> WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind Flickr: http://www.flickr.com/photos/fake51 BeWelcome: Fake51 Couchsurfing: Fake51 </hype> --PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php