That is actually easy...
You would first need a table probably with the coloums:
Required
---------
Song
Artist
Lyrics
Optional:
---------
SubmitedBy:
Dates (Cannot use date as it is main keyword)
Then when you add to the form just use your normal insert, and when you display the list just select the rows and order it by a variable sent by the url... example:
http://www.lyrics.com?SortBy=artist
$artist=$_GET["artist"];
$song=$_GET["song"];
$order=$_GET["SortBy"];
$result = mysql_query("SELECT * FROM lyrics ORDER BY ".$order." ASC");
$count=0;
if(mysql_num_rows($result))
{
echo '
<table>
<tr><td>Artist</td><td>Song</td><td>Submited By:</td>
</tr>';
while($row=mysql_fetch_array($result))
{
$count=$count+1;
$artist=$row["artist"];
$song=$row["song"];
$submitted=$row["submitedby"];
if($count <= $front_cols && $count==1){echo "";}
else if($count < $front_cols && $count > 1){echo "";}
else if($count==$front_cols){echo "";}
echo '
<tr><td>$artist</td><td>$song</td><td>$submitted</td>
</tr>';
if($count <= $front_cols && $count==1){echo "<br /><br />\n</td>\n";}
else if($count < $front_cols && $count > 1){echo "<br /><br />\n</td>\n";}
else if($count==$front_cols){echo "<br /><br />\n</td>\n";}
if($count==$front_cols){$count=0;}
}
if($count < $front_cols)
{
$spacer=($front_cols - $count) * 2;
echo "\n<td class=\"bodymd\" colspan=\"$spacer\"> </td>\n";
}
echo '</table>
';
}
else
{
echo '<div align="center"><font size="2" face="Arial, Helvetica, sans-serif">We are sorry.
We can\'t seem to find any lyrics.</font></div>
';
}