{"id":5917115,"date":"2015-03-19T14:03:24","date_gmt":"2015-03-19T14:03:24","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/xsl\/"},"modified":"2016-08-22T18:13:52","modified_gmt":"2016-08-22T18:13:52","slug":"xsl","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/xsl\/","title":{"rendered":"XSL"},"content":{"rendered":"<p>Hi, I&#8217;m trying to use the xsl transformations on a sql query, like you have done in your example. However, I get no output when I do that. When I leave the xsl transform, and just the query, I do get the proper results from the database.<\/p>\n<pre><code>&lt;table&gt;\n    &lt;xsl:copy-of select=&quot;\/table\/tr[1]&quot; \/&gt;\n      &lt;xsl:for-each select=&quot;\/table\/tr[position() != 1]&quot;&gt;\n         &lt;tr&gt;\n           &lt;xsl:for-each select=&quot;td&quot; \/&gt;\n             &lt;xsl:choose&gt;\n               &lt;xsl:when test=&quot;position () = 3&quot;&gt;\n                 &lt;td&gt;&lt;a href=&quot;\/wordpress\/speler-profiel\/&quot;&gt;&lt;xsl:value-of select=&quot;.&quot; \/&gt;&lt;\/a&gt;&lt;\/td&gt;\n               &lt;\/xsl:when&gt;\n               &lt;xsl:otherwise&gt;\n                 &lt;xsl:copy-of select=&quot;.&quot; \/&gt;\n               &lt;\/xsl:otherwise&gt;\n             &lt;\/xsl:choose&gt;\n           &lt;\/xsl:for-each&gt;\n         &lt;\/tr&gt;\n       &lt;\/xsl:for each&gt;\n     &lt;\/table&gt;<\/code><\/pre>\n<p>https:\/\/wordpress.org\/plugins\/sql-shortcode\/<\/p>\n","protected":false},"template":"","class_list":["post-5917115","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5917115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5917115\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=5917115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}