Wrap a href Tag Around Result

Hi, Is it possible to wrap an a href tag around a column in a resultset? For example: SELECT Firstname FROM Users; Matthew Mark Luke John Becomes: a href=index.php?action=view_userfirstname=MatthewMatthew/a a href=index.php?action=view_userfirstname=MarkMark/a a

Re: Wrap a href Tag Around Result

On Wednesday 07 December 2005 15:29, Shaun wrote: SELECT Firstname FROM Users; Matthew a href=index.php?action=view_userfirstname=MatthewMatthew/a I need to do this with pure SQL - no server side scripting... http://dev.mysql.com/doc/refman/4.1/en/string-functions.html CONCAT() perhaps.

Re: Wrap a href Tag Around Result

select CONCAT('a href=index.php?action=view_userfirstname=',Firstname,'',Firstname,'/a') from Users; Shaun wrote: Hi, Is it possible to wrap an a href tag around a column in a resultset? For example: SELECT Firstname FROM Users; Matthew Mark Luke John Becomes: a