[SOLVED] Prefix column names with table on SELECT * JOIN

[mylo]

Hello,

 

i've got two tables which i want to "SELECT * " and JOIN, but they have some fields named with the same column name. When i execute the select the fields overlap and i can't tell them apart.

 

Now, is there a way to prevent this (except of using unique names for fields, of course)?

Maybe i can prefix the columns in question with the table name on-the-fly.

 

 

[rhodesa]

the best way is to have unique names for each column...but you can also do it the manual way:

 

SELECT t1.id AS t1_id, t2.id AS t2_id FROM .... INNER JOIN .....

[mylo]

Well, this works, but i need to know the overlapping column names. I thought there is a more general way to prevent name collision, maybe a way to have all column names the table name as prefix.

[rhodesa]

'auto prefixing'...not that i'm aware of

 

you can try mysql_fetch_row(), which will return a numerical array (therefore no collisions), and then mysql_field_name() and mysql_field_table() to tell where the column comes from

[mylo]

That works. Thank you!