[SOLVED] AVG() query return, "Resource id #"

[pourmeanother]

I have the following code which I expect to display the average of the column named "column" from the table "tableone". Instead I get an output of "Resource id #2" (if column is the 2nd column).

 

<?php

$host="localhost";
$user="user";
$password="";
$database="databasename";

$cxn = mysql_connect($host, $user, $password) or die(mysql_error());

$db_selected = mysql_select_db($database);
if(!$db_selected)
{
     exit("Could not connect");
}
$query = "SELECT AVG('column') FROM tableone";
$result = mysql_query($query, $cxn);
if(!$result)
{
echo "N/A";
}
else
{
echo "<b>Average of column:</font> $result</b><br>";
}
mysql_close($cxn);
?>