If a record exist

Hi Orazo,

If statements can offer this kind of results you're looking for.

So if you're looking for a simple "no records found" vs "records are found" indicator, you can try something like this on your page after any searching criteria results:

<?php if (!$your_sectionRecords): ?>
No records were found!<br/><br/>

<?php elseif ($your_sectionRecords) : ?>

Record(s) were found!<br/><br/>

<?php endif ?>

There are many othre examples of using if statements both here on the forum and in my CMSB Cookbook http://www.thecmsbcookbook.com 

Hope that helps.

Jerry Kornbluth

Thank You Jerry! But it doesn'work for me.

I have this code 

list($reviewRecords, $reviewMetaData) = getRecords(array(
'tableName' => 'review',
'where' => 'restaurant = ' . getNumberFromEndOfUrl(),
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
$reviewRecord = @$reviewRecords[0]; // get first record

So i would like to have "no records found" 'where' => 'restaurant = ' . getNumberFromEndOfUrl(), 

Any suggestions about this?

instead of using ! (not) try using the empty function since you are testing an array.

$reviewRecord = @$reviewRecords[0]; // get first record

if (empty($reviewRecord))   {
  echo "no records found";
}