fetch object & join aliases

[AdamSelene]

I'm trying to use mysql_fetch_object with a join query that uses aliases, and I can't figure out how to reference the fields with the alias. This doesn't work:

$r = mysql_query("select d.*, r.* from table1 d inner join table2 r on d.id = r.id");
$o = mysql_fetch_object($r);
print $o->r.field;

So.. how do I access the 'field' column if it exists on both tables?

[AdamSelene]

Well - I just went ahead and added column aliases for the specific ones I needed. But if anyone knows how to make this work with wild cards, I'd still like to know.

[Roger_Ramjet]

Well now. One school of db design holds that all field names should be unique across the whole schema for just this sort of case. Others don't worry about it as they use a db engine that returns tablename.fieldname whenever it encounters duplicate field names. It so much depends upon the dialect of sql you are used to.

To get around this in mysql/php use mysql_fetch_array or mysql_fetch_row and work with the numeric array index ($row[0] etc), ie. the field order instead of the field names. Then you can use the *.

[kpzani]

You need to know what the fields have been named by mysql.

the best way is to run the query in the mysql client and look at the column headings - these should equal the field names.