MySQLi PHP Show If recordset field is empty

I see a Show If Recordset is/is not Empty option in the Server Behaviours panel but no Show If Field is/is not Empty. I'm using a MySQLi recordset and have tried this to only show a link if a recordset field is empty but I know the field isn't empty however it isn't displaying on the page:

<?php if($row_rsACT['SMTactwebsite'] != "") { ?>
<a href="http://<?php echo($rsACT->getColumnVal("SMTactwebsite")); ?>" class="list-group-item"><span class="glyphicon glyphicon-globe"></span> Official Website</a>
<?php } ?>

Hope you can help. Thank you.
NJ

the if statement should be:
<?php if($rsACT->getColumnVal("SMTactwebsite") != "") { ?>

I have a follow up question. This solution works fine when you are checking one column in the row. However, I have 3 columns. If there is data in any of the 3 database columns I need that total row to show. In your example above, I'm trying to expand the column to check 3 instead of 1. Thx

I figured this out: Using OR

<?php if($WADAstats_details->getColumnVal("oppo45") OR ($WADAstats_details->getColumnVal("oppoDate45")) OR ($WADAstats_details->getColumnVal("venue45"))!= "") { ?>
<?php } // Show if mysqli recordset empty ?>

Does "OR" work here? Isn't it...

<?php if($WADAstats_details->getColumnVal("oppo45") || ($WADAstats_details->getColumnVal("oppoDate45")) || ($WADAstats_details->getColumnVal("venue45")) !== "") { ?>
Content you want to show here if all three columns have no value/data.
<?php } // Show if mysqli recordset empty ?>

Thanks. Both seem to work fine.

Any idea on this. I'm trying to check to see if multiple columns are empty. This seems to work with one column. However, can't figure out how to get to check multiple colums. Need to check "oppo1", oppo2, oppo3.

<?php if ($WADAstats_details->getColumnVal("oppo1") == 0) { // Show if mysqli recordset empty ?>
This recordset field is empty
<?php } // Show if mysqli recordset empty ?>

Any idea on this. I'm trying to check to see if multiple columns are empty. This seems to work with one column. However, can't figure out how to get to check multiple colums. Need to check "oppo1", oppo2, oppo3.

<?php if ($WADAstats_details->getColumnVal("oppo1") == 0) { // Show if mysqli recordset empty ?>
This recordset field is empty
<?php } // Show if mysqli recordset empty ?>

What data type are the oppo1, 2 and 3 fields?

<?php if($WADAstats_details->getColumnVal("oppo1") == "" && $WADAstats_details->getColumnVal("oppo2") == "" && $WADAstats_details->getColumnVal("oppo3") == "") { // Show if mysqli recordset empty ?>
These recordset fields are all empty
<?php } // Show if mysqli recordset empty ?>

Thx Nathan. You are the man. You got it. I spent hours looking for an example of how to do this. I got close! Thx and hope this helps someone else.

No problem. I think you can also do IS NOT NULL, as opposed to == 0, if you're testing against a NULL value.
Happy to help.
NJ