ID: 8009 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Closed Bug Type: Feature/Change Request Operating System: All PHP Version: 4.0.3pl1 New Comment:
mysql_fetch_array() just uses the names reported by the mysql client library. use 'SELECT table.fieldname AS name' to given them different names. Previous Comments: ------------------------------------------------------------------------ [2000-11-28 07:17:57] [EMAIL PROTECTED] In the documentation it is said that if you use same column names the last one will win. That is so far ok. However I think the following statement could be correctly transferred in an assoc. array: SELECT tblOrderAddress.Street, tblDeliveryAdress.Street FROM tblCustomer AS tblOrderAddress, tblCustomer AS tblDeliveryAddress WHERE .....; It is correct that Street occurs twice as an attribute, but it is distinguishable by the preceding tablename. Isn't it possible to change mysql_fetch_array, so that tablenames, if stated, are included in the assoc Array building process? ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=8009&edit=1