[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