hyperlink in mysql table

[Anon]

I need to find out how to create a hyperlink in a mysql output table, which will also take the $faultid and input it into the mysql SELECT QUERY (which is what the hyperlink will run.)

Hope that makes sense.

This is what I have want:

cid name faultid description FURTHER_INFO
1 bob 234 broken pen hyperlink

(The hyperlink will give me further info on the fault)

Thanks in advance