Replace XML with MySql

1

Is there anyway to get my flash music player to read from MySql instead of an xml Playlist? I have just run into a problem on my site because i have well over 30,000 members and each member has their own playlist created automatically on my server. My hosting company has a limit on how many files can be within one folder so I want to convert my players from reading the XML files to read only from MySql.

here is now the player loads the XML Playlist :

lvOut = new LoadVars();
lvIn = new LoadVars();
lvIn.onLoad = function (success)
{
data_xml.load(“http://www.mysite.com/main/users/” + lvIn.playurl + “/playlist.xml”)
}
lvOut.folder = _level0.folder;
lvOut.sendAndLoad(“http://www.mysite.com/main/process.php”, lvIn, “POST”);

The code above pulls the query line send with the player and processes it with PHP, then sends it back to the player to tell what playlist to read from.

The proccess.php contains :


include("mysqlconnection.php");

$folder=$_POST['folder'];

$member_result = mysql_query("SELECT * FROM members WHERE member_id = '$folder'");
$member = mysql_fetch_object($member_result);

if($member->active == 1){
     echo "&playurl=$folder&";
}

mysql_close($db);

Thanks in advance!