[SOLVED] Getting ALL my records to display

[karatekid36]

Hey Everyone!

In this code, almost everything is working perfectly, but for my second query, I have six records that I want displayed in their own table like I have.  I know that a loop would probably work, but I am just really not sure how to go about this.  I would like the code to display a table of each of the records.  Any assistance would be great!

 

// Retrieve the user's information.
$query = "SELECT *, (SELECT COUNT(rating) FROM prof_ratings WHERE prof_id=$prof_id) AS total, ((SELECT SUM(rating) FROM prof_ratings WHERE prof_id=$prof_id) / (SELECT COUNT(rating) FROM prof_ratings WHERE prof_id=$prof_id)) AS rating	FROM professors WHERE prof_id=$prof_id";

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



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

// Create the form.
echo '<br /><br /><br /><br />
<table width="250" height="50" 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">' . $row['rating'] .'</td>
  </tr>
</table>';

$query2 = "SELECT * FROM prof_ratings";
$result2 = @mysql_query ($query2); // Run the query.


// Get the user's information.
$row = mysql_fetch_array ($result2);
echo'<br /><br />
<table width="400" border="2" cellspacing="0" cellpadding="5" align="center">
  <tr>
    <td width="74">Brother:</td>
    <td width="174">' . $row[2] .'</td>
   
<td width="174">Class:</td>
    <td width="174">' . $row[5] .'</td>

  </tr>
  <tr>	

    <td>Rating:</td>
    <td>' . $row[1] .'</td>
  
     <td>Date:</td>
    <td>' . $row[4] .'</td>

  </tr>
  <tr>
    <td>Comment:</td>
    <td colspan="3">' . $row[6] .'</td>
  </tr>
</table>';	

[vbnullchar]

<?php
$query2 = "SELECT * FROM prof_ratings";
$result2 = mysql_query ($query2); 

while($row2=mysql_fetch_array ($result2)) {
    echo $row2['field_name']; 
    echo $row2['field_name2']; 
    echo $row2['field_name3']; 
    echo $row2['field_name..n']; 
}
?>

[karatekid36]

thank you