select CONCAT('<a href="index.php?action=view_user&firstname=',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 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 > > > > > -- Marco Baroetto Parisi Ribes Informatica - Via Jervis, 60 - 10015 Ivrea (TO) - Italy Tel: +39-0125-62.78.50 - Fax: +39-0125-64.44.39 Web: http://www.grupporibes.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]