[SOLVED] Help!

[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

[nfr]

Something like this:

$record_id = $_REQUEST['record_id'];
mysql_select_db($database_db, $db);
$query = "SELECT audio FROM audio where id=$record_id";
$RS_record = mysql_query($query, $db) or die(mysql_error());
$row_RS_record = mysql_fetch_assoc($RS_record);
$audio = $row_RS_news_headline['audio'];
<?php echo $audio; ?>

You'll have to tidy it up for your application but the above should give you a headstart...

Regards,

Neil.

[steviez]

Hi,

Thanks for the answer, unfortunatly i forgot to say i am a complete beginner so i dont know anything. could you explain how to alter the code to work for me

Thanks

[steviez]

Problem solved THANK YOU!