Help with file download

[falon810]

This is probably a easy solution but i'm new to php so here I am wanting to pick someone's brain. I need help with a table.

		<?php
// Make a database Connection
mysql_connect("*******", "*******", "******") or die(mysql_error());
mysql_select_db("******") or die(mysql_error());

// Get all the data from the "sound" table
$result = mysql_query("SELECT * FROM sounds where origin='Emax'") 
or die(mysql_error());  

echo "<table border='1'>";
echo "<tr> <th>MP3 Preview</th><th>Wav File</th><th>Texture</th><th>Loop/Sound</th><th>Length</th><th>File Size</th> </tr>";


while($row = mysql_fetch_array( $result )) {
 $wavpath=$row['wav'];

echo "<tr><td>";
echo $row['mp3'];
echo "</td><td>"; 
echo ("<DD><A HREF='$wavpath'>Download</A></DD>\n"); 
echo "</td><td>"; 
echo $row['texture'];
echo "</td><td>"; 
echo $row['loop/sound'];
echo "</td><td>"; 
echo $row['length'];
echo "</td><td>"; 
echo $row['size'];
echo "</td></tr>"; 
} 
echo "</table>";

?> 

Currently this table does work, but instead of echo ("<DD><A HREF='$wavpath'>Download</A></DD>\n"); opening in windows media player I want this file to download. How do i go about doing this? Also currently i don't have anything in the mp3 field in the database but i will be putting the file path for the Mp3 version of the wave file in their but i want that to play in a embedded mp3 player when visitors click on preview. Can someone help me with how i go about doing both of these please, thanks in advanced for letting me pick your brain.

[bpat1434]

Well, I'll say this that your HTML doesn't validate. <dd> must be inside a <dl> element.

Anyway.... by posting the wav file, you can't define how they view/download the file. That's based on the browser and how the user has it set up for that specific file type.

If you want to force a download, you'd have to use [man]fopen/man or [man]file_get_contents/man to read the file, and send the proper headers to force a download (google it) and then send the contents of the file. Something like:

$file = file_get_contents('./file.wav');

header("Pragma: public"); // required
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private",false); // required for certain browsers
header("Content-Transfer-Encoding: binary");
header("Content-Type: application/octet-stream");
header("Content-Length: " . strlen($file));
header("Content-Disposition: attachment; filename=\"some_file.wav\";" );

echo $file;

Hope that helps.