Can't display query

[Anon]

I have the following query:
$query="select g.nombre, a.nombre, a.año from grupo as g, album as a
where g.nombre like '%".$buscar."%' and g.grupoid=a.grupoid";
and my tables are like this:
album (albumid int, grupoid int, nombre varchar(40) año int, estilo varchar (20) primary key albumid);
grupo (grupoid int, nombre varchar (25) primary key grupoid);

how can I display this sort of query I can't displya this way:
$result=mysql_query($query);
while($row=mysql_fetch_array($result))
{
echo"$row["a.nombre"]" ;

}
Thanks in advance.

[matto]

you want to be able to access the fields contained in $row by field name?

do:
$row = mysql_fetch_array($result, MYSQL_ASSOC)

this will give it back in form of an associative array (not as an enumerated array as before).

don't put "" around the $row[nombre]

[matto]

sorry, should read:

don't put "" around the $row["nombre"]
use: echo "something: ".$row["nombre"]." ...";