php关于sql语句输出的问题

Question

php的sql语句为$sql=“select count（courseid）from stucourse where courseid=1”，怎么讲sql的结果用echo或者是什么方式显示出来呢？

Answer 1

$sql = "select count(*) as VAR rom table";
$query = mysql_query($sql);
$row = mysql_fetch_array($query);
echo $row['VAR'];