moria123 Posted November 20, 2003 Share Posted November 20, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/1402-order-by-and-tables/ Share on other sites More sharing options...
triphis Posted November 20, 2003 Share Posted November 20, 2003 Have you tried \"ORDER BY game ASC\" ? That will put it in alphabetical order, and it might be going swcrewy because you don\'t have that. You do a lot of echoing. If my previous suggestion doesn\'t work, try the table outside of PHP, and using <?=$variable?> to call the variables. Quote Link to comment https://forums.phpfreaks.com/topic/1402-order-by-and-tables/#findComment-4657 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.