Jump to content

[SOLVED] Help!


steviez

Recommended Posts

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
Link to comment
https://forums.phpfreaks.com/topic/36072-solved-help/
Share on other sites


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.
Link to comment
https://forums.phpfreaks.com/topic/36072-solved-help/#findComment-171210
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.