Member Avatar for 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

  • 3 Contributors
  • 3 Replies
  • 75 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for urtrivedi

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

Member Avatar for dude1

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

Member Avatar for urtrivedi

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.