|
|
|
30)
{
$n=number_format($num_files/30);
echo "| ";
echo "Pages: ";
for ($i=0;$i<=$n;$i++)
{
$ii=$i+1;
echo " |";
}
echo " | ";
}
$rows="limit 30";
if(isset($_GET[page]))
{
$page=$_GET[page];
$start=$page*30;
$rows="limit $start,30";
}
$query = "SELECT * FROM dlm_files WHERE lyric_id='lyrics' and language!='english' ORDER BY artist $rows";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
?>
| Song |
Hits |
Play |
Lyrics |
Comments |
Rate |
Vote |
add";
}
else
{
$lyrics=" lyrics";
}
echo " ";
echo "| $filename | ";
echo "$hits | ";
echo "Play | ";
echo "$lyrics | ";
$query2="select id from posts where file_id='$id'";
$result2=mysql_query($query2);
$num=mysql_numrows($result2);
echo "$num Comments | ";
?>
|
|
|
|
|