2
I was able to get it working to some extent..
Basically the following code can get the top 10 songs sorted into 3 columns of title, artist and album.
I was also able to get the title to corresponding song file, but not for the artists (genre).
Thought I would share it here.
<?php
include "mainfile.php";
include "mainfile.php";
$query = 'SELECT xfid, title, artist, album, year, addinfo, track, genre, length, bitrate, frequence FROM dhoodi_debaser_files WHERE approved = 1 AND views > 0 ORDER BY views DESC LIMIT 10';
$result = mysql_query($query);
$nrows = mysql_num_rows($result);
if($nrows != 0)
{
print "<table border=1><tr><th>Song Name<th>Artist<th>Albumn";
for($j=0;$j<$nrows;$j++)
{
$row = mysql_fetch_array($result);
print "<tr><td><a href=(xoopsurl)/debaser/singlefile.php?id={$row['xfid']}>" . $row["title"];
print "<td>" . $row["artist"];
print "<td>" . $row["album"];
print "n";
}
print "</table>n";
}
else print "<p>Top Downlooads Not Available "
Download Dhivehi mp3s
[size=x-small]www.gnatoll.com[/size]