|
|\n";
$result = mysql_query("SELECT * FROM lyrics WHERE covered !='1' ORDER by title");
while ($row = mysql_fetch_array($result)) {
$firstletter = substr($row[title],0,1);
if ($firstletter != $firstletter_prev) {
echo "$firstletter |\n";
}
$firstletter_prev = $firstletter;
}
echo " "; $result = mysql_query("SELECT * FROM lyrics WHERE covered !='1' ORDER by title"); while ($row = mysql_fetch_array($result)) { $title_link = Modify_String($row[title]); $firstchar = substr($row[title],0,1); if ($firstchar != $firstchar_prev) { echo "$firstchar \n"; } echo " $row[title] \n"; $firstchar_prev = $firstchar; } ?> |