streaming m3u file generated by php

[mattennant]

Hello there i've been struggling with this for a while now and wonder if anyone out there can help me out.

I'm trying to create an m3u file to stream music in a kind of radio player. I want the list of mp3's to come from my database music uploads.

I've managed to generate the m3u file when manually entering the mp3 paths within a php file

see code below

[code]<?
header("Content-Type: audio/mpegurl");
header("Content-Disposition: attachment; filename=playlist.m3u");
print "http://www.myurl.co.uk/nowax/uploads/track1.mp3\r\n";
print "http://www.myurl.co.uk/nowax/uploads/track2.mp3\r\n";
?>[/code]

on the back of this sucess i tried to populate the mp3 paths from the relevent row in the database (see below)

[code]<?php require_once('../../connections_handcode/handcode.php'); ?>
<?php
header("Content-Type: audio/mpegurl");
header("Content-Disposition: attachment; filename=playlist.m3u");
$query = "SELECT track_upload  FROM music_uploads";
$result = @mysql_query ($query);
if  ($result){
while ($row = mysql_fetch_array($result, MYSQL_NUM)){
echo'http://www.myurl.co.uk$row[0]'."\n";
}
}else{
echo'error';
}
?>[/code]

I believe, although i'm not certain that the above code, does not put each mp3 on a seperate line as i need to for the generated m3u file.

I hope this is something simple

thanks in anticipation

matthew

[mainewoods]

Your single quotes are what are killing you:
[code]echo'http://www.myurl.co.uk$row[0]'."\n";[/code]
-$row[0] not translated to value
-replace single quotes with double quotes
[code]echo "http://www.myurl.co.uk$row[0]" ."\n";[/code]

[mainewoods]

you're missing a '/' after '.uk' as well

[mattennant]

that's the one - thanks so much, i can go to sleep happy now