Re: Foreign Keys Question
| From: | tedd | Date: | Thu, 11 Dec 2008 18:56:55 +0000 |
| Subject: | Re: Foreign Keys Question | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-284494@lists.php.net to get a copy of this message | ||
At 1:48 PM -0500 12/11/08, Robert Cummings wrote:
On Thu, 2008-12-11 at 13:27 -0500, Bastien Koert wrote: On Thu, Dec 11, 2008 at 12:56 PM, tedd <tedd.sperling@gmail.com>Rob: Good point. Maybe my old way of doing that was the best. Simply get the ID's needed from one table and then open the necessary tables accordingly. In other words, stop worrying about the number of times I'm going to the store to buy things because going once might result in the things being too heavy for me to carry home -- if that makes sense. Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.comDoes anyone have any example code to show me the actual syntax?Joins should allow you to pull the data from the table in one query You want to be careful using joins though. If you were to pull all that data in one shot using joins you would create a large data transfer mostly containing redundant data. Cheers, Rob.