Despite reading postings and the cmsbcookbook I still cannot get to grips with the if statement
All of the below works fine it loads and displays records from the database without problem, but what I want to do is if there are no records is to put some text instead i.e
"sorry there are no listings at this present time please visit us again soon"
At the moment when there are no records its just a blank page
But for the life of me I just cannot work out how to do it, what should I be adding to it?
Thanks Mel
All the code works just fine if there are records
<?php
// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/*********/public_html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
// load records
list($biosRecords, $biosMetaData) = getRecords(array(
'tableName' => 'bios',
'where' => 'ne1="1"',
));
?>
Below displays thumbnail and link to detail page without problem
<?php foreach ($biosRecords as $biosRecord): ?><!-- start master foreach-->
<div class="bg-1 bioFrame">
<div class="name"><?php echo $biosRecord['name'] ?> </div>
<!-- ....... This section deals with picture ...... -->
<div align="center" class="img_border"><?php foreach ($biosRecord['newimage'] as $upload): ?>
<?php if ($upload['isImage']): ?>
<a href="<?php echo $biosRecord['_link'] ?>" target="_self"><img src="<?php echo get_custom_watermark_url($upload['urlPath'], '110watermarkSmall.png') ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="<?php echo $biosRecord['name'] ?>"></a>
<?php else: ?>
<?php endif ?>
</div>
<?php endforeach ?>
<div align="right"style="padding-top:3px;">
<a href="<?php echo $biosRecord['_link'] ?>" target="_self">View My Details</a>
</div>
<!-- finish bioFrame--></div>
<!-- finish master foreach--><?php endforeach ?>