mp3 playback from BLOB

[dbmasters]

How can I playback an mp3 that was uploaded into a MySQL BLOB field?

I have (or want to have) playback and download options. For playback so far I have these headers:

ob_end_clean();
header("Content-Disposition: inline; filename=".$row["filename"]."");
header("Content-type: ".$row["filetype"]."");

and for download:

ob_end_clean();
header("Content-Disposition: attachment; filename=".$row["filename"]."");
header("Content-type: ".$row["filetype"]."");

The download strts with the proper filename, but has no data. I need to do a binary read of some sort on the BLOB data. Can anyone kick me in the right direction to get this done?

I have uploaded it via:

$data=addslashes(fread(fopen($file, "r"), filesize($file)));

and put $data into the blob. Is that how I read it to play it back as well?

Any advice?

[dbmasters]

FYI:

for download I am doing this:

$result = MySQLQuery("SELECT * FROM songs WHERE id=$id ORDER BY title ASC", $QueryError_Email, $QueryError_Browser);
if(mysql_num_rows($result))
{
	while($row = mysql_fetch_array($result))
	{
		$song=@mysql_result($result, 0, "file");
		ob_end_clean();
		header("Content-Disposition: attachment; filename=".$row["filename"]."");
		header("Content-type: ".$row["filetype"]."");
		echo $song;
	}
}

For playback I am doing this:

$result = MySQLQuery("SELECT * FROM songs WHERE id=$id ORDER BY title ASC", $QueryError_Email, $QueryError_Browser);
if(mysql_num_rows($result))
{
	while($row = mysql_fetch_array($result))
	{
		$song=@mysql_result($result, 0, "file");
		ob_end_clean();
		header("Content-Disposition: inline; filename=".$row["filename"]."");
		header("Content-type: ".$row["filetype"]."");
		echo $song;
	}
}

I have done this before with images, documents and such, but never multimedia. Please help...

[jnuneznyc]

Why the ob_end_clean()? I usually just set the type, size (if available) and the filename and thne just begin to echo the data.

[dbmasters]

Hey, thanks for the response!

Yes, I have tried it that way as well. Here is the problems I am having, regardless if it is a cleaned buffer or not.

Upon playback, the associated mp3 program opens and then pops up an error that it can't find the specified file.

Upon download it prompts me for download, with the proper filename that I tell it to, but the file it saves is the actual HTML code of the page the link is on.

Any thoughts?

Oh, and yes the size is available in a seperate field of the table if that helps at all.