Some PHP/HTML help please

Ok for real I actually have a prob, is there anyway I can get this to sort alphabetically?

// ##############################
// Select which database "data" is in,
mysql_select_db("********",$db);

if ($id) {

} else {

// ##############################
// Show the collection entries, starting with the first item in database "data"
$result = mysql_query("SELECT * FROM data ORDER BY id",$db);

if ($myrow = mysql_fetch_array($result)) {

// ##############################
// Display the items if there are items to display
// Create the design also to make it look more professional
do {

echo ("<p align=center><table width=100% cellpadding=0 cellspacing=1 border=0>");
echo ("<tr><td bgcolor=#000000 width=15% align=right><b><font face=verdana size=2 color=orange>Category: </font></b></td>");
echo ("<td bgcolor=#CCCCCC width=85% valign=top><font face=verdana size=2 color=black>");
printf("%s\n", $myrow["category"]);
echo ("</font></td></tr>");
echo ("<p align=center><table width=100% cellpadding=0 cellspacing=1 border=0>");
echo ("<tr><td bgcolor=#000000 width=15% align=right><b><font face=verdana size=2 color=orange>Album Artist: </font></b></td>");
echo ("<td bgcolor=#CCCCCC width=85% valign=top><font face=verdana size=2 color=black>");
printf("%s\n", $myrow["artist"]);
echo ("</font></td></tr>");
echo ("<p align=center><table width=100% cellpadding=0 cellspacing=1 border=0>");
echo ("<tr><td bgcolor=#000000 width=15% align=right><b><font face=verdana size=2 color=orange>Album Title: </font></b></td>");
echo ("<td bgcolor=#CCCCCC width=85% valign=top><font face=verdana size=2 color=black>");
printf("%s\n", $myrow["title"]);
echo ("</font></td></tr>");
echo ("<p align=center><table width=100% cellpadding=0 cellspacing=1 border=0>");
echo ("<tr><td bgcolor=#000000 width=15% align=right><b><font face=verdana size=2 color=orange>Album Rating: </font></b></td>");
echo ("<td bgcolor=#CCCCCC width=85% valign=top><font face=verdana size=2 color=black>");
printf("%s\n", $myrow["rating"]);
echo ("</font></td></tr>");
echo ("<p align=center><table width=100% cellpadding=0 cellspacing=1 border=0>");
echo ("<tr><td bgcolor=#000000 width=15% align=right><b><font face=verdana size=2 color=orange>Album Cover: </font></b></td>");
echo ("<td bgcolor=#CCCCCC width=85% valign=top><font face=verdana size=2 color=black>");
printf("%s\n", $myrow["cover"]);
echo ("</font></td></tr></table>");

// Add center divider
echo ("<p align=center><table width=100% cellpadding=0 cellspacing=1 border=0>");
echo ("<tr><td bgcolor=#000000 width=100% align=center><b><font face=verdana size=2 color=orange>~~~~</font></b></td>");
echo ("<td bgcolor=#CCCCCC width=85% valign=top><font face=verdana size=2 color=black>");
echo ("</table></p>");

} while ($myrow = mysql_fetch_array($result));

} else {

// ##############################
// If there are no entries to display, then alert the user
echo "<p align=center><font face=verdana size=2 color=black>Sorry, no entries were found.</font>";

}

}

?>

Bump for a real problem...

all you need to do is change you sql query to order by which ever column you want to sort by.. so it would be something like:


Hope that helps, if that isn't what you were explaining can you explain more.

Thanks

Thanks man, just wasn't clicking to me lol one of those days.

Special7 said:

Thanks man, just wasn't clicking to me lol one of those days.

Click to expand...

hehe, yeh we all have those sort of days... i tend to go away from my desk for 10 mins and see if i realise whats wrong.. if not post on Expert Exchange!! lol