Returning a partial list

Hi Dennis,

I think we found a solution. First, we're going to need to find out if there are any records for each condition. Put this code somewhere below where you do your query, but before your output:

<?php
$square_foot[0]=0;
$square_foot[1]=0;
$square_foot[2]=0;

foreach($productRecords as $record){
if($record['square_footage']<25)
$square_foot[0]++;
else if($record['square_footage']>=2500 && $record['square_footage']<=3000 )
$square_foot[1]++;
else if($record['square_footage']>=3000)
$square_foot[2]++;
}
?>

We now have an array that tells us how many records exist that fit each condition (0 if there are none)

Now we can output like this:

<div>
<?php foreach($productRecords as $record): ?>
<?php if($square_foot[0]==0): ?>
*NO RECORDS*
<?php elseif($record['square_footage']<2500): ?>
*RECORD*
<?php endif ?>
<?php endforeach ?>
</div>

<div>
<?php foreach($productRecords as $record): ?>
<?php if($square_foot[1]==0): ?>
*NO RECORDS*
<?php elseif($record['square_footage']>=2500 && $record['square_footager']<=3000): ?>
*RECORD*
<?php endif ?>
<?php endforeach ?>
</div>

<div>
<?php foreach($productRecords as $record): ?>
<?php if($square_foot[2]==0): ?>
*NO RECORDS*
<?php elseif($record['square_footage']>3000): ?>
*RECORD*
<?php endif ?>
<?php endforeach ?>
</div>

Here, you can replace *NO RECORDS* with whatever you want to display if there are no records for that condition. You can also replace *RECORD* with whatever you want if there are records that match that category.

Give that a try and let me know if that works for you.