How do I ouput one row of data?

Anon

Hi, two questions. First, is the query below in the right format?

Second, if it looks ok, how do I output the resulting single row of data in the subsequent printf line? I tried mysql_fetch_row and mysql_fetch_array but neither produce any output? Thanks!

$query = "SELECT AVG(column3), SUM(column4), AVG(column5) FROM tablename WHERE column1 ='Joe'";

$result = mysql_query("$query",$db);

if ($myrow = mysql_fetch_row($result)) {

printf("<tr><td><center>%s</center></td><td><center>%s</center></td><td><center>$%s</center></td></tr>", $myrow["column3"], $myrow["column4"], $myrow["column5"]);
}

Anon

Nevermind, looks like I left out the "AS whatever" after each aggregate function. Working fine now.