<?
if ($id=="topSong") {
if($genre=='%')
$genre_str = " genere like '%$genre%' ";
else
$genre_str = " genere = '$genre' ";
}
if (empty($offset)) {
$offset=0;
}
if (strlen($records)) {
$dispPages=$records;
} else {
$dispPages=10;
}
$wcnt=$offset;
$num31=$dispPages*10;
// $sql = "select songs.*, unix_timestamp(date) as date1 from songs where $genre_str order by $sort_column $sort_type limit $offset,$dispPages";
$sql= "select s.*, unix_timestamp(s.date) as date1,u.username from
songs s, user_profile u where s.uid=u.uid and $genre_str order by $sort_column $sort_type limit $offset,$dispPages";
$db1=mysql_query($sql);
echo mysql_error();
if (mysql_num_rows($db1)==0) {
echo "<center><span class=warning>No Submissions Found.</span></center><br>";
} else {
?>
<table width="100%" border="0" cellpadding="2" cellspacing="1">
<tr>
<th>
<?
if($sort_column=="title")
{
if($sort_type=="desc")
{ $sort_type="asc"; $img="images/up.gif"; }
else
{ $sort_type="desc"; $img="images/down.gif"; }
?>
<a class=thnav href=index.php?<? echo "sort_column=title&genre=" .urlencode($genre)."&sort_type=$sort_type&records=$records"; ?>>Song Title</a>
<img border="0" src="<? echo $img; ?>" width="10" height="10">
<?
}
else
{
?>
<a class=thnav href=index.php?<? echo "sort_column=title&genre=" .urlencode($genre)."&sort_type=asc&records=$records"; ?>>Song Title</a>
<? } ?>
</th>
<th><span style="font-size:12px">Genre</span></th>
<th><span style="font-size:11px">Comments</span></th>
<th><span style="font-size:11px">Rank</span></th>
<th><span style="font-size:11px">Submitted</span></th>
<th>
<?
if($sort_column=="username")
{
if($sort_type=="desc")
{ $sort_type="asc"; $img="images/up.gif"; }
else
{ $sort_type="desc"; $img="images/down.gif"; }
?>
<a class=thnav href=index.php?<? echo "sort_column=username&genre=" .urlencode($genre)."&sort_type=$sort_type&records=$records"; ?> >Member</a>
<img src=<? echo $img; ?> height=10 width=10 align=absbottom >
<?
}
else
{
?>
<a class=thnav href=index.php?<? echo "sort_column=username&genre=" .urlencode($genre)."&sort_type=$sort_type&records=$records"; ?> >Member</a>
<? } ?>
</th>
</tr>
<?
$db2=mysql_query("select count(*) from songs s, user_profile u where s.uid=u.uid and $genre_str");
$rrr = mysql_fetch_array($db2);
$num = $rrr[0];
$link2 = "index.php?records=$records";
$gotopage =table_offset($pageno,$num,$wcnt,$dispPages,$num31,$link2);
while ($r1=mysql_fetch_array($db1)) {
$db2=mysql_query("select * from users where user_id='$r1[uid]'");
$r2=mysql_fetch_array($db2);
$db3=mysql_query("select * from genere where id='$r1[genere]'");
$r3=mysql_fetch_array($db3);
?>
<tr>
<??>
<td class="row1" onmouseover="this.style.backgroundColor='666666'; " onmouseout="this.style.backgroundColor='333333';" align=center><b><a href="song.php?<? echo "id=$r1[uid]&act1=$r1[genere]&act2=$r1[song_id]"; ?>"><? echo $r1[title]; ?></a></b></td>
<td class="row2" align=center><span style="font-size:11px"><? echo $r3[genere]; ?></span></td>
<?
// insert # of comments
$res_com = mysql_query("SELECT count(cid) FROM rank WHERE songid = ' $r1[song_id]'");
$row_com = mysql_fetch_array($res_com); ?>
<td class="row2" align=center><span class=tinywht><? echo $row_com[0]; ?></span></td>
<?
// Determines if singer wants to be ranked
if ($r1[rankit] == "n") {
$song_rank2 = "";
} else {
// Inserts individual song rank
$sql_song2 = "select sum(rank),count(cid) from rank where songid = '$r1[song_id]' and rank > 0";
$res_song2 = mysql_query($sql_song2);
$row_song2 = mysql_fetch_array($res_song2);
if ($row_song2[1] <= 2)
{
$song_rank2 = "-";
} else {
$song_rank2 = $r1[ranking];
} }?>
<td class="row2" align=center><span class=tinywht><? echo $song_rank2; ?></span></td>
<td class="row2" align=center><span class=tinywht><? echo date('M jS',$r1[date1]); ?></span></td>
<td class="row1" onmouseover="this.style.backgroundColor='666666'; " onmouseout="this.style.backgroundColor='333333';" align=center><b><a href="profile.php?id=<? echo $r1[uid]; ?>"><? echo $r2[username]; ?></a></b></td>
</tr>
<? } ?>
<tr>
<td colspan="6" class="gensmall"><? echo $gotopage; ?></td>
</tr>
<? } ?>
</table>
ol. 
