Qualified column name in mysql_fetch_arr

[prycejones]

Hi gang,
When I try the following my data comes out fine!

$row = mysql_fetch_array($result);
print $row["rate"];

But when I try the following to qualify the column name with the table name nothing comes out.

$row = mysql_fetch_array($result);
print $row["vatrates.rate"];

Can anyone tell me how I can quote the table name against a column name please. ( I have a query to do with two tables and they have the same column names!) thanx.
Pryce

[zalath]

I can't remember how to do that, but instead you can use something like this:

"SELECT a.field, <b>b.field as field2</b> FROM ..."

This way you can assign aliases to the field names on the other table.

-L-

[prycejones]

Ah yes, aliases, I could do it thay way couldn't I? I wonder if I could it any other way.
Thanx L