Title: Table column hyperlink
Last modified: September 1, 2016

---

# Table column hyperlink

 *  Resolved [hfaero](https://wordpress.org/support/users/hfaero/)
 * (@hfaero)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/table-column-hyperlink/)
 * I have a simple but dynamic csv file created by a PHP script with one column 
   just for testing. So my page text looks like:
 * [gdoc key=”[http://hfaero.com/test.csv”%5D](http://hfaero.com/test.csv”%5D) and
   this returns a list of flight numbers like ‘ANZ123’. For each flight number I
   want my users to click on it and be directed to a URL that is dependent on the
   flight number like:
 * {flightnumber from csv file}
 * I’ve added the gdoc_table_html function to my themes functions.php file and tried
   the following:
 * [gdoc key=”[http://hfaero.com/test.csv&#8221](http://hfaero.com/test.csv&#8221);
   gdoc_table_html query=” query=”select [flight](http://flightaware.com/flight/live/)
   as flight”]
 * but to no avail, I just get the return from test.csv
 * I’ve also tried putting the HTML code in the base query (escaping the brackets
   as directed) so that it is visible in the CSV return but unless I have the full
   URL displayed I just get the test of the original query.
 * Ideally I’d like to achieve this with a MySQL connection direct to my database.
 * Is this something I’m ever going to achieve with this plugin?
 * Thanks for any help.
 * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)

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

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/table-column-hyperlink/#post-7494040)
 * You misunderstand the filter function; your HTML code should be part of the CSV
   field value, not the query.
 *  Thread Starter [hfaero](https://wordpress.org/support/users/hfaero/)
 * (@hfaero)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/table-column-hyperlink/#post-7494178)
 * OK, but since my CSV file is created from a MySQL query would I need to escape
   the <> characters in the MySQL query or not? Thanks for the help so far.
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/table-column-hyperlink/#post-7494179)
 * You would need to ensure that valid HTML is inside the CSV field value. How you
   get it there is dependent on the specifics of your pipeline.

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

The topic ‘Table column hyperlink’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [html](https://wordpress.org/support/topic-tag/html/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * 3 replies
 * 2 participants
 * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/)
 * Last activity: [9 years, 11 months ago](https://wordpress.org/support/topic/table-column-hyperlink/#post-7494179)
 * Status: resolved