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>";
}
}
?>
// ##############################
// 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>";
}
}
?>
Last edited: