[SOLVED] Fairly Easy SQL statement

[karatekid36]

I would like to get all from the professors table and a count of the ratings from the prof_rating table and I need both where the prof_id equals the prof_id variable which comes from the url.

 

"SELECT *, (SELECT COUNT(rating) FROM prof_ratings WHERE prof_id=$prof_id) AS total FROM professors WHERE prof_id=$prof_id";

 

This is not the right sql statement, or at least I am not sure because it is displaying nothing in the following code:

 

$query = "SELECT *, (SELECT COUNT(rating) FROM prof_ratings WHERE prof_id=$prof_id) AS total FROM professors WHERE prof_id=$prof_id";	

$result = @mysql_query ($query); // Run the query.



// Get the user's information.
$row = mysql_fetch_array ($result, MYSQL_NUM);

// Create the form.
echo '<br /><br /><br /><br />
<table width="250" height="100" border="0" cellpadding="0" cellspacing="0" align="center">
  <tr>
  <td colspan="3" align="center"><b>' . $row[2] .', ' . $row[1] .'</b></td>
  </tr>
  <tr>
    <td width="195" scope="row">Total Ratings: </td>
    <td width="112" colspan="2">' . $row['total'] .'</td>
  </tr>
  <tr>
    <td scope="row">Average Rating: </td>
    <td colspan="2"> </td>
  </tr>
</table>';