Supress Blank Rows - PHP

[woodbridge]

I am adding lines of information to committee members drawn from MySQL
database. Not all members have daytime or mobile phone numbers or email
addresses so I dont want blank rows to appear where that is the case. I have
written the following if statements, the idea being that if the rows are not
NULL the data will appear and a break will be applied. However, when I add the
<br> or <br /> tag I get parsing errors, no matter where I write the tags. I
am sure this is just a syntax issue but cant work out what he code whould be.
If i add it at the end of the lines it is fine, but then it throws a line break
even when there is no data. Any help gratefully recieved. Thanks, John

<?php if($rsCommitteeMembers->Fields('day_tel')!=NULL) echo
$rsCommitteeMembers->Fields('day_tel'); ?>
<?php if($rsCommitteeMembers->Fields('mobile_phone')!=NULL) echo
$rsCommitteeMembers->Fields('mobile_phone'); ?>

[David Powers]

woodbridge wrote:

> <?php if($rsCommitteeMembers->Fields('day_tel')!=NULL) echo
> $rsCommitteeMembers->Fields('day_tel'); ?>
> <?php if($rsCommitteeMembers->Fields('mobile_phone')!=NULL) echo
> $rsCommitteeMembers->Fields('mobile_phone'); ?>

This should do what you want.

<?php if($rsCommitteeMembers->Fields('day_tel')!=NULL) echo
$rsCommitteeMembers->Fields('day_tel').'<br />'; ?>
<?php if($rsCommitteeMembers->Fields('mobile_phone')!=NULL) echo
$rsCommitteeMembers->Fields('mobile_phone').'<br />'; ?>


--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[woodbridge]

David

It does - it was that little full stop I overlooked!! - many thanks indeed, so easy when you know how. John

[David Powers]

woodbridge wrote:

> It does - it was that little full stop I overlooked!!

The PHP concatenation operator (aka period, full stop, dot) is tiny, and
very easy to miss. It causes many people grief when they first start PHP
(myself included).

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]