ok, for some reason it doesn't come out grouped as I want it to!! anyone
know why??? I want it to come out like this...
1--Family Fun 4 Package 22.0000
1--sdffdsdf 22.0000
2--Monkey Bear 22.0000
2--dasw 2.0000
2--asdads 44.0000
but it comes out in this order instead!!!
1--sdffdsdf 22.0000
2--Monkey Bear 22.0000
2--dasw 2.0000
1--Family Fun 4 Package 22.0000
2--asdads 44.0000
here's the code
<CFQUERY DATASOURCE=#dsn# name="get_prod">
SELECT name, price, show, prod_type_id, id
FROM prod
</cfquery>
<TABLE CELLSPACING="4" CELLPADDING="0" BORDER="0" bgcolor="#E7E7DA">
<cfoutput query="get_prod" group="prod_type_id">
<TR>
<TD>#Prod_type_id#--#name# </td><TD>#price# </td>
</tr>
</cfoutput>
</table>
PLEASE HELP!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
