If less than X records

Maybe this will help:

http://www.interactivetools.com/forum/gforum.cgi?post=59802#59802

-aev-

Hi Rob,

You can check the record meta details (as suggested above) or the array count directly like this:

<?php if (count($productsRecords) < 4): ?>

Hope that helps!

Excellent, thanks... although upon implementing it I realised I need another criteria...

The productsRecord have a field 'Display' (with answers Yes/No).

It needs to be an IF statement whereby count of records with Display = Yes is less than 4.

Is the easiest way to run another call of the productsRecord list with a where display=yes clause, and then run the count within that?

i.e.

<?php
list($productsRecords, $productsMetaData) = getRecords(array(
'tableName' => 'products',
'where' => " online = 'Yes'",
?>

<?php if (count($productsRecords) < 4): ?>

That will work won't it? The count of less than 4 will be running from this new listing of only where records are online yes?

Fingers crossed...

Thanks again

Can you filter out records that aren't: "Display = 'Yes' " in the where? ie:

'where' => " online = 'Yes' AND Display = 'Yes' ",