Counting records in GroupBy categories

Hi Greg,

Haven't heard from you in a while.

Thanks for the insights, It worked perfectly with a few minor tweaks.

Best,

Jerry Kornbluth

Just in case it can help someone else, here's my final code.

At the top of the page:

<?php list($accountsRecords, $accountsMetaData) = getRecords(array(
'tableName' => 'accounts',
'orderBy' => 'practice_country ASC, practice_state ASC',
'groupBy' => 'practice_country, practice_state',
)); ?>

And in the Body:

<div align="center" style="width:80%; text-align:left"><span class="heading_font"><b>PROVIDER MAPS</b><br />
<br />
</span> <span class="text_font">We have provider listings in the following Countries/States/Provinces<br />
Choose the one that's right for you</span><br />
<br />
<div class="rTable">
<div class="rTableBody">
<?php $old_group = ''; // init blank var.

foreach ($accountsRecords as $record): ?>
<?php $group = $record['practice_country:label']; // load sub-group value from record. ?>
<?php $stateCount = mysql_count('accounts', mysql_escapef("`practice_state` = ? AND `hidden`= '0' ",$record['practice_state']));  // revised to not include hidden records ?>
<?php $countryCount = mysql_count('accounts', mysql_escapef("`practice_country` = ? AND `hidden`= '0' ",$record['practice_country'])); // revised to not include hidden records ?>
<div class="rTableRow">
<div class="rTableCell text_font">
<?php if ($group !== $old_group) {echo "<h3>$group ($countryCount)</h3>";} ?>
<?php $state = ($record['practice_state']); ?>
<?php $country = ($record['practice_country:label']); ?>
<?php $recnum = ($record['num']); ?>
<a href="maps.php?state=<?php echo $state ?>&country=<?php echo $country ?>"><?php echo ucwords($state); ?> (<?php echo $stateCount ?>) </a></div>
</div>
<?PHP $old_group = $group; // retain sub-group name before moving to new record. ?>
<?php endforeach; ?>
</div>
</div>