records. I want them to be displayed in groups of the category. For
example:
Category1
record1
record1
Category2
record3
record4
I'm trying to make it look like the list in the center of this page:
http://www.babycenter.com/polls/preconception
When I use group="category", it only loops through the category
once. Should I then do a cfloop and get the others of the group?
Or in that case, should I just not group and loop through the whole
thing, doing a category compare?
I figured that there might be a sensible way to group these and spit
out all the records.
<cfquery name="retrieve_archives" datasource="eatsmart">
SELECT p_id,p_question,p_category,p_date_last_used,p_status
FROM fsnep_polls
WHERE p_status = 2
ORDER BY p_category,p_date_last_used DESC
</cfquery>
<!-- content -->
<ul>
<cfoutput query="retrieve_archives" group="p_category">
<br>#p_category#
<li><a href=""> </cfoutput>
</ul>
thanks.
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
