Displaying DATA IN Alphabetical Order

tegwin15

I have a nice script which I found somewhere that displays DATA from a DB in a nice Grid. When I display the information however, it only displays it in the order in which they are in the DB. Is there is a way to get it to display the data in this grid by a field, say location or name...

Here is the script..

<HTML>
<HEAD>
<TITLE>Retrieving Data from a Database</TITLE>
</HEAD>
<BODY>
<CENTER><B><FONT SIZE="10" COLOR="#6666FF"><H1>Centra EMEA Asset Register</H1></FONT></B></CENTER><BR>
<?php
// Set the variables for the database access:
$Host = "localhost";
$User = "root";
$Password = "";
$DBName = "emeaasset";
$TableName = "asset";

$Link = mysql_connect ($Host, $User, $Password);

$Query = "SELECT * from $TableName";
$Result = mysql_db_query ($DBName, $Query, $Link);

// Create a table.
print ("<TABLE BORDER=1 WIDTH=\"75%\" CELLSPACING=1 CELLPADDING=1 ALIGN=CENTER>\n");
print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP><B>Full Name</FONT></B></TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP><B>Location</B></TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP><B>Machine Type</B></TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP><B>Machine Make</B></TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP><B>Asset #</B></TD>\n");
print ("<TD ALIGN=CENTER VALIGN=TOP><B>Serial #</B></TD>\n");
print ("</TR>\n");

// Fetch the results from the database.
while ($Row = mysql_fetch_array ($Result)) {
 	print ("<TR ALIGN=CENTER VALIGN=TOP>\n");
 	print ("<TD ALIGN=CENTER VALIGN=TOP>$Row[fullname]</TD>\n");
 	print ("<TD ALIGN=CENTER VALIGN=TOP>$Row[location]</TD>\n");
 	print ("<TD ALIGN=CENTER VALIGN=TOP>$Row[machinetype]</TD>\n");
 	print ("<TD ALIGN=CENTER VALIGN=TOP>$Row[machinemake]</TD>\n");
	print ("<TD ALIGN=CENTER VALIGN=TOP>$Row[assetnum]</TD>\n");
 	print ("<TD ALIGN=CENTER VALIGN=TOP>$Row[serialnum]</TD>\n");


//print ("<TD ALIGN=CENTER VALIGN=TOP>$Row[Comments]</TD>\n");
print ("</TR>\n");
}
mysql_close ($Link);
print ("</TABLE>\n");
?>
</BODY>
</HTML>

laserlight

change the query such that it uses ORDER BY location (or name), e.g.

$Query = "SELECT * from $TableName ORDER BY location";

btw, I think you should use mysql_query() instead of mysql_db_query() as the latter is deprecated.
You may have to use mysql_select_db() first in that case, since mysql_db_query() is not the same as mysql_query()

scoppc

$Query = "SELECT * from $TableName ORDER BY location ASC";
for ascending order and...

$Query = "SELECT * from $TableName ORDER BY location DESC";
for descending...