> 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
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]

Reply via email to