30) { $n=number_format($num_files/30); 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()); ?> add"; } else { $lyrics=" lyrics"; } echo ""; echo ""; echo ""; echo ""; echo ""; $query2="select id from posts where file_id='$id'"; $result2=mysql_query($query2); $num=mysql_numrows($result2); echo ""; ?>
"; echo "Pages: "; for ($i=0;$i<=$n;$i++) { $ii=$i+1; echo "$ii |"; } echo "
Song Hits Play Lyrics Comments Rate Vote
$filename$hitsPlay$lyrics$num Comments