[RESOLVED] Formatting output when values are null

[Viktig609]

Hi everyone - first of all, sorry if this has been covered already, but I have spent a while searching around old threads and have come up with nothing to this problem.

OK, I have a basic script that searches a mySQL table and displays a series of addresses for my organisation. This all works fine, but on a cosmetic level I am unhappy when there are addresses of different lengths that leave a blank space i.e.

Contact 1
address line 1
address line 2
address line 3
address line 4

Contact 2
address line1
address line2

address line 4

I would like the script to remove the blank line when it comes across a blank value. I know I could use something like:

if(empty($row['address3'])) {

but I'm not sure how to tell it not to print the line with the blank value....

Hope this makes sense, and thanks in advance if anyone can assist 🙂

[Najjar]

If you are displaying the values as you have in your question then you need to
check before the <tr><td> starts like this:
if(!empty($row['address3'])) {
echo '<tr><td>
'.$row['address3'].'
</td></tr>';
}

[Viktig609]

Ah! Thank you! Yes, that works perfectly. I was nearly there, but as has been frequently said on this forum, a second (or more) heads works wonders 😃

[Najjar]

Glad it works