TotalRows == 0
Simple check to see any ANY fields exist in a recordset. Value is always 1
<?php echo $rsPDF->TotalRows;
?>
<?php if($rsPDF->TotalRows==0) { ?>
<img src="imgz/pdf.png" width="20" height="20" alt="PDF Version" border="0"> lone soul
<?php } else { ?>
<?php if($rsPDF->getColumnVal("pdfOne")){ ?>
<div class="a"><A href="PDFs/<?php echo($rsPDF->getColumnVal("pdfOne")); ?>"><img src="imgz/pdf.png" width="20" height="20" alt="PDF Version" border="0"> <?php echo($rsPDF->getColumnVal("pdfTitleOne")); ?></A> </div>
<?php } ?>
<?php if($rsPDF->getColumnVal("pdfTwo")){ ?>
<div class="a"><A href="PDFs/<?php echo($rsPDF->getColumnVal("pdfOne")); ?>"><img src="imgz/pdf.png" width="20" height="20" alt="PDF Version" border="0"> <?php echo($rsPDF->getColumnVal("pdfTitleTwo")); ?></A> </div>
<?php } ?>
<?php if($rsPDF->getColumnVal("pdfThree")){ ?>
<div class="a"><A href="PDFs/<?php echo($rsPDF->getColumnVal("pdfOne")); ?>"><img src="imgz/pdf.png" width="20" height="20" alt="PDF Version" border="0"> <?php echo($rsPDF->getColumnVal("pdfTitleThree")); ?></A> </div>
<?php } ?>
<?php } ?>
Screen shots show one case WITH records and once case WITHOUT but in each case it TotalRows is 1
I could have sworn this worked before as well as it's derivatives like :
if ($recordset->TotalRows !='')