Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › SQL to show if NOT x and Not x and records exists ie greater than 0

SQL to show if NOT x and Not x and records exists ie greater than 0

Thread began 5/09/2022 2:19 pm by jo271221 | Last modified 5/09/2022 7:25 pm by Ray Borduin | 117 views | 1 replies |

5/09/2022 2:19 pm | #1 jo271221

SQL to show if NOT x and Not x and records exists ie greater than 0

Details in PM

5/09/2022 7:25 pm | #2 Ray BorduinWebAssist

php:

if (($WADAtbl_directorylistings->getColumnVal("fldpackage") ."" == "hotSite" || $WADAtbl_directorylistings->getColumnVal("fldpackage") ."" == "hotPage" ) && $RecordsetName->TotalRows ) {

and

php:

<?php

$postCount = countPostsForhorse($WADAhorses->getColumnVal('horseid'));

if ($postCount) {

?>

<li><a href="<?php echo $serverDomain; ?>/details/horse/<?php echo strtolower(str_replace(' ','_',trim($WADAhorses->getColumnVal("horse_name")))); ?>.<?php echo($WADAhorses->getColumnVal("horseid")); ?>"><i class="far fa-clock"></i>Timeline Posts: # <?php echo($postCount); ?></a></li>

<?php

}

?>

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.