concat mysql question

[lacompsr]

i have a table holding files and each has a unique id eg. 1, 2, 3 etc.
i have a column in the table i want to contan the link that should be
<a href=\"localhost/upload/dltest.php?id=(number)
eg.
<a href=\"localhost/upload/dltest.php?id=2
i want that link to be auto created from the other information in the table when a new item is added

i was told tiggers would be what i need but ive tried and cant get it working
ive got this so far:
SELECT CONCAT('<a href="localhost/upload/dltest.php?id=',id,'">')
FROM uploads

am i even close would anyone mind giving me a hand
would it be a tigger or what could do this for me

thanks

[urtrivedi]

Your syntax is working fine it has no problem. If you are getting an error then post that error message.

[dude1]

the error is
"not allowed to return a result set from a trigger"

[urtrivedi]

I guess you are writing that selectect statement in trigger. I think only insert update delete statements are allowed in triggers.