Is there a better way to write this?

["Chris Payne" <chris@planetoxygene.com>]

Hi there everyone,

I'm re-writing the messageboard that my boss uses, and I wanted to know if there's a cleaner way to do the below code.  The first bit gets the name of the forum by the ID sent from the previous page to display the forum name, then the second bit gets some of the info for the message listing.  The forum name is NOT stored in the actual messages table, it's in the forum index table I created.

The code I use is:

<?   

include("../../connectionstart.php");

$query = "SELECT * FROM forums WHERE ForumID = '$ForumID' ORDER BY ForumID ASC";

$sql_result = mysql_query($query,$connection)
 or die("Couldn't execute query.");

while ($row = mysql_fetch_array($sql_result)) {

 $Forum = $row["Forum"];
 
};

$query = "SELECT * FROM forummessages WHERE ForumID = '$ForumID' ORDER BY ForumID ASC";

$sql_result = mysql_query($query,$connection)
 or die("Couldn't execute query.");

while ($row = mysql_fetch_array($sql_result)) {

 $id = $row["id"];
 $MessageID = $row["MessageID"];
 $ForumID = $row["ForumID"];
 $subject = $row["subject"];

};
?>

Thanks for taking a look :-)

Chris