PHP hide field if empty

I have a recordset with several fields that display in a table.... If a field is empty (no data); I'd like to hide that table row so a blank area doesn't appear.

I see a hide/show recordset if empty, but no way to assign it to just a field is empty.

you would need to hand code an if statement around the code for the row.


for example, the code for the row may loo like;

<tr>
<th>A Label:</th>
<td><?php echo($row_recordsetName['columnName']); ?></td>
</tr>

you could add an if statement around that to only show if the column is not blank:

<?php if($row_recordsetName['columnName'] != "") { ?>
<tr>
<th>A Label:</th>
<td><?php echo($row_recordsetName['columnName']); ?></td>
</tr>
<?php } ?>

Hi Jason:

Thanks for your help.

I get this error:
Parse error: syntax error, unexpected ')', expecting ',' or ';' in /hsphere/local/home/xcski/xcski.org/member_ads.php on line 143 {{{143 is the <td align="left" code }}}

Here's my code:

<?php if($row_rsEquipment['price'] != "") { ?>
<tr>
<td align="left" valign="top" bgcolor="#FBFCFD" ><?php echo($row_rsEquipment['price'])); ?> USD</td>
</tr>
<?php } ?>

you have an extra parenthesis:

<td align="left" valign="top" bgcolor="#FBFCFD" ><?php echo($row_rsEquipment['price'])); ?> USD</td>

should be:

<td align="left" valign="top" bgcolor="#FBFCFD" ><?php echo($row_rsEquipment['price']); ?> USD</td>

Hi Jason:
Thank you ... I had an extra parenthesis in there. It worked perfectly and thanks once again for you quick response and help. Always appreciate it!

No worries, glad to hear it's working.

Hi Jason,

If I am using data assist details page, If I want to do this to all my fields, should I delete the "show if no record found" at the bottom of the page..I am asking because I kept getting a syntax error when trying to do it on all the fields.

Thx in advance!

no, you dont need to delete the show if no records are found section.


if your getting a syntax error, include the full error and a copy of your page and I will look into the cause of it.

I got it..I think I needed to put the data in tables.

ok, glad to hear it is working.