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" <[EMAIL PROTECTED]>
To: ""olinux"" <[EMAIL PROTECTED]>
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]