|
|
Posted by Rainman on 03/23/06 22:54
In my query, I make a couple of INNER JOINS to tables which happen to
have some fields of the same column name. I use "SELECT * ..." and so
numerous columns are returned from the query. The problem is that when
I use mysql_fetch_assoc() function, data in the columns of the same name
overwrite each other in the array that's returned.
Is there a non-tedious way to get around this? The tedious way is to
list each column name in the SELECT list (instead of *) using "AS" to
rename appropriate fields, but with so many columns returned, this will
be a headache, especially since these tables are still evolving.
Mark
Navigation:
[Reply to this message]
|