Title: Link Support
Last modified: August 21, 2016

---

# Link Support

 *  Resolved [nicarley](https://wordpress.org/support/users/nicarley/)
 * (@nicarley)
 * [12 years, 8 months ago](https://wordpress.org/support/topic/link-support/)
 * I have a database with website and email addresses. Is there a way to form the
   output of a column to be a clickable link?
 * [http://wordpress.org/plugins/dbview/](http://wordpress.org/plugins/dbview/)

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/)
 * (@john-ackers)
 * [12 years, 8 months ago](https://wordpress.org/support/topic/link-support/#post-4121527)
 * 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.
 *  Thread Starter [nicarley](https://wordpress.org/support/users/nicarley/)
 * (@nicarley)
 * [12 years, 8 months ago](https://wordpress.org/support/topic/link-support/#post-4121535)
 * 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.
 *  Plugin Author [john ackers](https://wordpress.org/support/users/john-ackers/)
 * (@john-ackers)
 * [12 years, 8 months ago](https://wordpress.org/support/topic/link-support/#post-4121538)
 * 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](http://wordpress.org/plugins/dbview/screenshots/).
 *  Thread Starter [nicarley](https://wordpress.org/support/users/nicarley/)
 * (@nicarley)
 * [12 years, 8 months ago](https://wordpress.org/support/topic/link-support/#post-4121544)
 * Hey thanks man that works like a charm!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Link Support’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/dbview.svg)
 * [dbview](https://wordpress.org/plugins/dbview/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/dbview/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/dbview/)
 * [Active Topics](https://wordpress.org/support/plugin/dbview/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/dbview/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/dbview/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [nicarley](https://wordpress.org/support/users/nicarley/)
 * Last activity: [12 years, 8 months ago](https://wordpress.org/support/topic/link-support/#post-4121544)
 * Status: resolved