Grouping output from a database
Posted: Thu Apr 24, 2003 7:09 pm
I have a site
http://www.motorcyclesinretrospect.com/ ... ontent=cal
with a calendar of events.
I need to group the items by location, my field is State
What I want for example if there were 2 records from Maine it would look like
Maine
Date1 Event
Date2 Event
Maryland
Date1 Event.
I am not sure how to do this I don't think Group By in the SQL Statement is the answer here but I am not sure.
Thanks
John
http://www.motorcyclesinretrospect.com/ ... ontent=cal
with a calendar of events.
I need to group the items by location, my field is State
What I want for example if there were 2 records from Maine it would look like
Maine
Date1 Event
Date2 Event
Maryland
Date1 Event.
I am not sure how to do this I don't think Group By in the SQL Statement is the answer here but I am not sure.
Thanks
John