PHP SQL - phpmyadmin: wrap sql result in html

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

phpmyadmin: wrap sql result in html

tlviewer

2005-05-20, 3:58 am

hello,

In phpMyAdmin, I pick a DB, then click 'Query' at the top. I then
enter some sql like below. I want to wrap each resulting row so that
it gives me an executable anchor tag. However, our beloved App
derails me and escapes all the html. The text is nicely readable,
but I want the working html, instead. I looked in the config. file
but nothing seemed to fit my needs.

SELECT filename, ConCat( '<a target="_top" href="ms-its:',
chm.path, '/', chm.filename, '::/', chap.url, '">',
replace(chap.title, "<", "<"), '</a>' ) as LinkedTitle
FROM chm

Short of diving into the source, what can I do? On my windows
box I have a custom Perl interface to do what I want, but here on
SuSE I'm trying to get by with phpMyAdmin.

tia,
tlviewer

Sponsored Links