Returning a partial list

Hi Dennis,

The easiest way to do this would be like this:

First, make sure the records being returned are sorted by square footage:

<?php
list($productRecords,$productMetaData) = getRecords(array(
'tableName' => 'products',
'orderBy' => 'square_footage ASC',
));
?>

This will return all of the records. This is how we'll print it out to organize it into the different categories:

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

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

<div>
<?php foreach($productRecords as $record): ?>
<?php if($record['square_footage']>3000): ?>
*RECORD*
<?php endif ?>
<?php endforeach ?>
</div>

All you need to do is change the names to match what you have in your database. Where it says *RECORD* you'll output whatever record information you want.

Hope that helps.

Thanks Jason! Exactly what I needed.

If I may follow up with an additional request/question...


This project has two major sections - A multi-record section of HOMES and a multi-record section of COMMUNITIES.

Not all the homes are available in all the communities, and the same home will have a different price in each community.

In each HOMES record, I have a field for a price in each community; i.e. Community ABC Price _______, Community XYZ Price _______.

What I need is this:

When displaying a COMMUNITYdetail page, I need to display a list of only the HOMES records that have an entry in the correct COMMUNITY_ABC_PRICE field.

I get that I can do <?php if ($homesRecord['price_communityABC'] != "" ): ?> show this <?php endif ?>

but what I need is for the "communityABC" part of the line above to change based on the COMMUNITYdetail page being displayed. This, unfortunately, it not yet something I now how to code.

Hopefully I've explained this sufficiently.

Thanks in advance for your help.

Hi,

I think we can get that done. I have a question.

When you go to the detail page with the different community, how is the community name displayed in the url?
(ex: detail.php?community_name=*COMMUNITYNAME*)

Also, what is the naming convention you use in your home table for prices? Is it price_*COMMUNITYNAME*?

Let me know.
Thanks

Hi,

We can try this:

Anywhere above where you're going to output potential price information, put this line:
<?php $field="price_".$_SERVER['QUERY_STRING']; ?>

After that, you can use this line:
<?php if ($homesRecord[$field] != "" ): ?> show this <?php endif ?>

Give that a try and let me know how it goes.

Thanks so much Jason. I'll be testing this out soon and will share my results.

- Dennis

Hi Jason,

This works perfectly. Thanks so much for your help.

-Dennis

Hi again Jason - one last question...

For this code:

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

How would I add a condition to display some code when there are no records fitting that criteria?

Naturally speaking:
When Plans <2500 square feet is none, then do this.

Thanks again for your help.

Hi,

How we go about this really depends on exactly what you want to do. For example, we could change the code you just sent me to this:
<div>
<?php foreach($productRecords as $record): ?>
<?php if($record['square_footage']<2500): ?>
*RECORD*
<?php else: ?>
*CONDITION NOT MET CODE*
<?php endif ?>
<?php endforeach ?>
</div>

In this example, the *CONDITION NOT MET CODE* will execute when the variable $record['square_footage'] is not less than 2500. This means it will execute if it's equal to 2500, or greater than 2500.

Is this what you're looking for? Let me know.