[ic] Creating forums using SQL queries
Steven Potter
interchange-users@interchange.redhat.com
Fri Dec 28 22:24:01 2001
I'm trying to setup an order page where the customers can select which
charity they would like a portion of their order donated to.
The first thing I would like them to do is select which state the
charity is located in. This is what I am thinking:
[loop list="[query sql="select distinct state from table where 1=1 order
by state" type=list]"]
<option>[sql-state]</option>
[/loop]
I'm sure there are some syntax errors in there. My question is, is this
the best way to do it? Is there some way of accomplishing this without
the query tag?
Thanks
Steven Potter