[Resolved] Path question

[m_tCh]

I have a field in my database called "info" that contains a unique Id for each record. Example:

SHS-SM.3.2.92.K.3

Employees use this id by naming a supporting word document the same name and placing it in a folder (all docs are in the same folder) on our share drive. Using same example:

SHS-SM.3.2.92.K.3.doc

When people use my search page online, it currently returns the names of each record. I also want it to return a convenient link that opens this document from the share drive so they can update it as they need to. The exact url needs to be in this format:

\_schwan02\dept_su\Share\Interdepartmental\Projects\Working_SU_Projects\SHS_RM_Built_to_Sell[B]SHS-SM.3.2.92.K.3[/B].doc

How can i make this exact link with field "info" being the bold part in each link?

Thank you very much for your help!

[akillez]

include the 'info' field in your select query
then as output you could use:

print("<A HREF='\\\\_schwan02\\dept_su\\Share\\Interdepartmental\\Projects\\Working_SU_Projects\\SHS_RM_Built_to_Sell\\" . $info . ".doc'>" . $info . "</A>");