Re: [PHP-DB] grabbing from multiple tables
[email protected] (Karl DeSaulniers)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]> wrote: >> No, 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> Karl DeSaulniers Design Drumm http://designdrumm.com