$conn = mysql_connect('silo.cs.indiana.edu:16248', 'dgerman', 'sp00n'); if ($conn) { if (mysql_select_db("demoOne")) { // echo "I can select the database.
"; $query = "select movieNum, avg(rating) as ratings from projectRatings group by movieNum order by ratings desc "; $result = @mysql_query($query); ?>
} else { echo "I can connect but I can't select the database.
Movie Average Rating while ($row = mysql_fetch_row($result)) { echo " " . $row[0] . " " . $row[1]; } ?>
"; } } else { echo "I cannot connect.
"; } ?>