Download Manager

[Jezz]

Im creating a download page, and a download manager for a site, but I do not know how to read in the location of a file from the database, and display it as a hyperlink. I can read in static text from the table (this just displays on the page as a static line of text), but if I put the location of the file in the database table, how do I then display it as a link, which can be clicked on to start the download of that file.

Although I can figure out how to display a specific file location as a hyperlink, I don't know how to create a generic script, that will turn any file location entered into the table into a hyperlink.

I would be very grateful for any suggestions.

[dustbuster]

Did you try something like this?

//connect to your database
//make your query
$query="select * from downloads where id=chosenId";
$result = mysql_query($query);
$row=mysql_fetch_array($result);
echo "<a href=\"".$row['file_location']."\">Download your file here</a>";

[Jezz]

That looks very useful, thankyou.