Yes.
This demo works for me
select 'john smith' as 'my name', 'john.smith@gmail.com' as 'my email', 'http://www.smiths-group.com/' as 'my website'
and using these two PHP snippets above the 2nd and 3rd columns:
return "<a href='mailto:$value'>$name</a>";
return "<a href='$value'>$name</a>";
You get email and website links.
Ok, I guess I’m confused as to where to put the PHP snippets.
If I have my select statement as select email from table.
I put the dbview shorcode on a page, where do I input the snippet code?
Thanks for all your help, this is a really valuable plugin.
load the query, then execute it so the table appears and there should be two rows at the top of the table. The first is column names and the second is the PHP snippets. Click around your email column on the second row until a box opens as per the second screenshot.
Hey thanks man that works like a charm!