[RESOLVED] need a variable with from DB

[jasondavis]

I am having trouble, I have a query that JOINs a few mysql tables and on 2 of these it shares a fields name "auto_id" now I am having trouble with this code below, where $row['auto_id'] is returning 1 result but I need the other, there are 2 fields with the name auto_id and I need to know how to display the second one, any ideas?

<?PHP



while($row=mysql_fetch_assoc($result)){

echo $row['auto_id']


}


?>

[jasondavis]

ok just an update to get it working I changed assoc to mysql_fetch_array and started using $row['0'] instead and that does the trick but I would love to know if there is a way to do this with assoc when there are mutiple names that collide

[dagon]

give one of them an alias

select auto_id as auto_idX, ...

[johanafm]

SELECT tableA.auto_id AS whatever, tableB.auto_id AS somethingElse, tableC.auto_id AS another_one FROM ...

[jasondavis]

thanks