[ic] PREFIX-change for [query] ???

[Kyle Cook]

At 04:33 PM 9/27/01, you wrote:

>is there such a thing ? the manual says so, but so
>far I havent gotten it to work.
>
>Any ideas ?
>thanks!



  Not sure what your looking for, but maybe this will help:
(need to change the sql statement etc to match your data)

[query more=1 list=1 ml=15
sql="SELECT man,cat ................
ORDER BY man,cat"]

[on-match]
spit out once before list starts
[/on-match]

[list]

[sql-change 1]
[condition][sql-param man][/condition]

         spit out when field man changes : [sql-param man]<br>

         [sql-change 2]
         [condition][sql-param category][/condition]

         spit out when field cat changes,
         but only if man changed also (nested):
         [sql-param man]<br>

         [/sql-change 2]

[/sql-change 1]


spit out for every match .......<br>

[/list]

[on-match]
spit out this once list is complete
[/on-match]

[more-list]
[decade-next][/decade-next][decade-prev][/decade-prev]<br>
[match-count] matches found. Displaying [matches].<br>
[more]<br>
[/more-list]

[no-match]
Sorry, there were no matches found.<br>
[/no-match]
[/query]


Kyle Cook