Re: Mysql join and aliasing with mysql_fetch_object()

> 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 richard@zend.com address is an endangered species -- Use ceo@l-i-e.com 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