Linking to File Locations

[Anon]

Hi there! Does anybody have some PHP code to list a number of files from a MySQL database and publish a link to it using file:/// ?

I thought this would be pretty easy though I seem to be having some trouble.

To explain further I would like a My SQL table as follows

Description of file
File Location

i.e

Description : Latest Stock Figures
Location: I:\sotck figures\stock.xls

then a php page that list all the files in this database and at the end of each line a link to the file.

[Anon]

What exactly is the difficulty you're having? You didn't
say exactly, so all we can do is guess--but it does occur
to me to wonder if the spaces in the pathname could
be part of the problem. Neither IE nor NS has any
problems with spaces when you use the file-open
dialog box to look at a local file, of course, but
perhaps when it's part of a regular URL in a link
it might be a problem.

[Anon]

Hi!

Yes sorry I think it is to do with the spaces, although MySQL also strips the \ out of the file name.

Cheers