Re: Re: loading a db table into a php array from mysql
| From: | Rick Widmer | Date: | Thu, 02 Jan 2003 09:25:18 +0000 |
| Subject: | Re: Re: loading a db table into a php array from mysql | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-129926@lists.php.net to get a copy of this message | ||
At 06:32 AM 1/1/03 -0500, David T-G wrote:
I still don't get what a left or right or outer or inner join is...The reason I chose LEFT JOIN are: o You get better control over how the query is executed. o Values from the first table are returned even if there is no associated entry in the second table. For eaxample if no building or room was set on an entry in my previous query, the rest of the data will still be returned.
Do you know of any (on the web) which will give me the background?http://www.devshed.com/Server_Side/MySQL/Join/page1.html http://www.devshed.com/Server_Side/MySQL/Normal http://www.devshed.com/Server_Side/MySQL/SQLJoins/page1.html