Re: grabbing from multiple tables
| From: | Karl DeSaulniers | Date: | Sat, 01 May 2010 09:00:27 +0000 |
| Subject: | Re: grabbing from multiple tables | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47112@lists.php.net to get a copy of this message | ||
Thank you Peter... again.. :)
Which would be the source field and which the target field?
Karl
On May 1, 2010, at 3:22 AM, Peter Lind wrote:
On 30 April 2010 20:49, Karl DeSaulniers <karl@designdrumm.com> wrote:Karl DeSaulniers Design Drumm http://designdrumm.comNo, please confuse me. I need to know this stuff. @Peter thanks for that introduction to foreign keys. Since my productoptions table is based off of items in products, optionGroups and options, would I use foreign keys for this?If I read you correct, your productoptions table is basically a lookup table and as such all your fields should be foreign keys. Because, each field is a reference to another table - and it's vital to data consistency that they cannot point to a row in a table that doesn't exist. --<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>