Re: Foreign Keys Question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx>

 > > Does 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.

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.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux