Created
October 7, 2011 23:11
-
-
Save dpdexter/1271562 to your computer and use it in GitHub Desktop.
Getting BrilliantRetail Category Images
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{exp:query sql="SELECT * FROM exp_br_category WHERE parent_id = (SELECT category_id FROM exp_br_category WHERE url_title = 'products') ORDER BY sort"} | |
<h2>{title}</h2> | |
{url_title} | |
<br /> | |
{image} | |
<br /> | |
{detail} | |
<hr /> | |
{/exp:query} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Note the call to "WHERE url_title = 'products'" in the internal SQL statement. Products should probably be replaced with a dynamic segment variable