building categories using sql

[Peter Hicks <peter@wine-trader.com>]

******    message to minivend-users from Peter Hicks <peter@wine-trader.com>     ******

hello list,

I am attempting to build a list of categories using the following
method:

[sql type=list
      query="select distinct varietal from products order by varietal
   " ]
[sql-param varietal]
[/sql]

What I would like to do is to make this a list of links that would
produce a page containing all items that belong in this category. Do I
have to pass the variable to the sql list on the next page to loop out
all the items? I seem to be at a loss on this one. Thanks for the help!

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list