Wrap <a href> Tag Around Result

["Shaun" <suppressed>]

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_user&firstname=Matthew">Matthew</a>
<a href="index.php?action=view_user&firstname=Mark">Mark</a>
<a href="index.php?action=view_user&firstname=Luke">Luke</a>
<a href="index.php?action=view_user&firstname=John">John</a>

I need to do this with pure SQL - no server side scripting...

Thanks for your advice 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed