[ic] product group

[Darnell Hudson]

I have worked at this for a while and I still can not get the products 
to display in each product group or category. I have tried to use query 
to get it to display. This what I have.


[loop search]
[query
    type=list
    label=products
    prefix=products
    list_prefix=products_list
    table=products
    ml=none
    sql=|
     SELECT * FROM `products`
     WHERE `active` <> 1
     ORDER BY prod_group category description
|]
[products_list]

[products-change 1][condition][products-field prod_group][/condition]
  <h1>[products-data products prod_group]</h1>
[/products-change 1]

[products-change 2][condition][products-field category][/condition]
  <h2>[products-data products category]</h2>
[/products-change 2]

    <a href="[area [products-code]]"
    >[products-data products description]</a>

[/products_list]
[/query]
[/loop]