I have the following code....
<html>
<title>Releases</title
<?php
$db = mysql_connect("localhost", "XXXX", "XXXXX");
mysql_select_db("XXXXXX" ,$db);
$title = "Mazza\'s Place";
$result = mysql_query("SELECT * FROM releases ORDER BY game", $db);
echo "Release Dates";
echo "<table border=1>n";
echo "<tr><td><b>Game Title</b></td><td><b>Format</b></td><td><b>Developer</b></td><td><b>Release Date</b></td></tr>n";
while ($myrow = mysql_fetch_row($result)) {
printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>n", $myrow[1], $myrow[3], $myrow[4], $myrow[2]);
}
echo "</table>n";
?>
</html>
When I view it (www.mazzas-place.com/nuke/modules/Releases/index2.php) it just comes out as plain text, not in a table.... But when I take the ORDER BY thing out, it works fine... (www.mazzas-place.com/nuke/modules.php?name=Releases).
How do I get the first one to go into a table? Thanks