steviez Posted January 28, 2007 Share Posted January 28, 2007 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=41Please can someone help.Thanks Link to comment https://forums.phpfreaks.com/topic/36072-solved-help/ Share on other sites More sharing options...
nfr Posted January 28, 2007 Share Posted January 28, 2007 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 More sharing options...
steviez Posted January 28, 2007 Author Share Posted January 28, 2007 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 meThanks Link to comment https://forums.phpfreaks.com/topic/36072-solved-help/#findComment-171212 Share on other sites More sharing options...
steviez Posted January 28, 2007 Author Share Posted January 28, 2007 Problem solved THANK YOU! Link to comment https://forums.phpfreaks.com/topic/36072-solved-help/#findComment-171225 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.