Anonymous

<?

require ("includes/db.php");


        $table_name2 = "rating";
        $connection = @mysql_connect($localhost, $dbuser, $dbpass) or die ("Couldn't Connect to database");
        $db = @mysql_select_db($dbname, $connection) or die("Couldn't select database");
        $sql = "select compid, avg(quest1) from $table_name2 WHERE compid = '2007167606' group by compid";
        $result = @mysql_query($sql,$connection) or die(mysql_error());

        while ($row = mysql_fetch_array($result)) {   
		
                $id = $row["id"];
				$compid = $row["compid"];
				$quest1 = $row["quest1"];

}

echo ''.$compid.'-'.$quest1.'<br>';

?>