I am polling a query from my database. It displayed correctly. I am trying to now get it to auto hyperlink so that each spec field is linked to a file name with the same spec number. Each file is a pdf.

in it's place. I am still getting the same results. There are no extra spaces in the database entry they are exactly the same as the file name. Is there a way to strip all spaces from a string/Variable?

Now how do I change the link to open in a iframe of a diffident page. Example Index.php has a iframe on the right that the spec.php loads in (that have my links) and a iframe on the right side that I would like the PDF files to open in.