Retrieving a pdf

[novabcfc]

Hi,
I am using e107 php mysql based CMS

I have a Tables:
e107_user
e107_user_extended_struct

I have used a javascript in the past to retrieve a pdf file from a file location appending the site url to the pdf.

I can not use that anymore as it doen't protect my client personal information.

What I want to do is have the mysql read the e107_user or e107_user_extended_struct for the client report number and produce a link to the file.

So it would need to verifie client ID and read the report number they have entered. Thus making it more secure, because file number is brought by the client id.

[novabcfc]

My table is as follows

user_id user_name user_loginname
1 todd 22N3D0000
2 tom 114680000
3 terry 222Q69133
4 wally 1232456578


My files are located in a folder on the server lets say /stationwest/reports

The user would be logged into the website there for a connection to the db is established.

How can I call to the db retrieve the user_loginname (22N3D0000 for example) and produce a link to the file in the /reports folder, and if the report is not there make a text statement " not available, yet!" or something like that.