Re: 2 while loops - 2 tables
| From: | olinux | Date: | Fri, 16 Mar 2001 21:39:10 +0000 |
| Subject: | Re: 2 while loops - 2 tables | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-7553@lists.php.net to get a copy of this message | ||
Do you mean JOIN the tables and then SELECT?
>
> The best way to do this is to structure your SQL statement to grab both
> apartment and
> feature information into one recordset... this simplifies the code alot
and
> makes it easier to use.
>
> Ryan Flynn
> Practical web development/design
> www.ryanflynn.com
----- Original Message -----
From: "Ryan Flynn" <ryan@ryanflynn.com>
To: ""olinux"" <olnx@yahoo.com>
Sent: Thursday, March 15, 2001 7:40 PM
Subject: Re: [PHP-DB] 2 while loops - 2 tables
> _____________________________________________
> Apartment 1 | feature1
> apt_address1 | feature2
> apt_address2 | feature3
> _________________|_____________________________
> Apartment 2 | feature1
> apt_address1 | feature2
> apt_address2 | feature3
> _________________|_____________________________
> Apartment 3 | feature1
> apt_address1 | feature2
> apt_address2 | feature3
> _________________|_____________________________
>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com