> select tableA.*, tableB.* from tableA,
> left join tableB ON tableA.keyfield = tableB.keyfield
>
> When I then try to access the column "keyfield", after using
select tableA.keyfield as mykeyfield, tableA.*, tableB.* ...
Unless you actually need *EVERY* field, do *NOT* use tableA.*, tableB.*
Every piece of data you ask for takes time and resources in MySQL and PHP.
--
WARNING [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
--
PHP General 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]
