List page categorized by field

3 posts by 2 authors in: Forums > CMS Builder
Last Post: March 29, 2008   (RSS)

By steve_e - March 29, 2008

I'd like to have the records of the list (or index?) page appear sorted by a field from the record.

So, for example, if the section gave details of cats, with age, name, address and breed as fields, I would like to list all Manx cats, followed by all tabby cats or whatever.

But I'd only like the field label (eg 'Manx') to appear once, as a heading. How would I set the logic for that? I've tried a couple of different 'for each' and 'if' variations but my coding skills are pretty minimal...

Re: [steve_e] List page categorized by field

By Dave - March 29, 2008

Hi Steve,

Sort by breed first, then whatever field you want to sort on next. Then... Add this bit of code to your list records block:

<?php foreach ($listRows as $record): ?>
...
<?php if ($record['breed'] != @$lastBreed): ?>
<h1><?php echo $record['breed'] ?></h1>
<?php $lastBreed = $record['breed']; endif ?>
...
<?php endforeach ?>

Basically, we just keep a copy of the breed from the last record in $lastBreed, and if it changes we show a heading.

Hope that helps! Let me know if you need any more assistance with that.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] List page categorized by field

By steve_e - March 29, 2008

Hi Dave -
Excellent, thanks very much!
Best wishes,
Steve.