Here is the code which selects the necessary data - the name of the field is 'message'.
# getting chosen message from database and displaying it
$query3 = "select * from $mcountry where incr = '$mes1'";
$result3 = MYSQL_QUERY($query3, $connection) or die("Couldn't execute query3!");
while ($row3 = mysql_fetch_array($result3)) {
$fromid = $mes3;
$subid = $mes2;
$gdate = $row3['gdate'];
$msg = $row3['message'];
$messid = $mes1;
$toid = $row3['recipient'];
}
$query4 = "update $mcountry set viewed = '0' where incr = '$mes1'";
$result4 = MYSQL_QUERY($query4, $connection) or die("Couldn't execute query4!");
$display2 = "<tr height=80% valign=top><td valign=top><b>From:</b> $fromid<br><b>Subject:</b> $subid";
$display2 .= "<br>Game Date: $gdate<p>$msg";
$display2 .= "<tr height=10% bgcolor=biege><td align=center>";
$display2 .= "<form method=post action='mc.php'>";
$query = "select * from $country where country = '$fromid'";
$result = MYSQL_QUERY($query, $connection) or die("Couldn't execute query2!");
$row = mysql_fetch_array($result);
$rel = $row['relation'];
if ($rel >= '0') {
$display2 .="<input type=submit name=rep value=Reply> ";
}
$display2 .= "<input type=submit name=del value=Delete> ";
$display2 .= "<input type=submit name=cancel value=Clear></form>";