creating links within table results

[Jay]

You want something like this (read it very carefully):
select concat('<a href=\'linkpage.php?value=',value,'\'>',value,'</a>') from table

This would return each row with the value as a hyperlink (if outputted directly).