Selecting From Multiple Tables

[kneff]

I have a couple tables I'm trying to pull information from and display but something's not going right. The query returns the correct info when I put it into phpmyadmin, and mysql_num_rows shows that rows were returned but it won't display for some reason. The line br is output but other than that the html comes up blank. Any ideas?

$result = mysql_query("SELECT distro_info.*, distro_format.* FROM distro_info,distro_format WHERE (distro_info.recordFormat = distro_format.formatId)");

while ($myrow = mysql_fetch_array($result)) 
{ 
echo $myrow["distro_info.recordBand"];
echo "<br>";
}

[coreyp_1]

echo $myrow["recordBand"];