Help pulling songs from a database

[steviez]

Hi,

On my website i want to be able to stream some music, the only problem is that the file names are stored in a database. i need to some code to pull a song from the database. I have sorted the sql side but now need the php code fopr it.

Where i want my song to be i put <?php echo $mp3_track ?>

I now need to pull the track from the database using the following sql code:

SELECT audio FROM audio where id=41

Please can someone help.

Thanks

[artacus]

1) Use descriptive subjects please.

2) What exactly is your question? It looks like you've got all the parts here. I'm guessing you need help on actually embedding the mp3 but who knows.

[bibby]

This?

[code]
$qr="SELECT audio FROM audio where id=41";
if($q=mysql_query($qr))
{
    if(($n=mysql_num_rows($q))>0)
    {
        // good query + result
        $r=mysql_fetch_row($q);
        $mp3track=$r[0];
    }
    else
        echo "good query, no result though";
}
else
  echo "that query didn't run. --> $qr";

[/code]