Dynamic removal of text if field is empty using PHP

[cp:fusion]

I have a mySQL database which has some fields which may, or may not be empty. I
wish to display them in the following way using PHP:- Result 1; Result 2;
Result 3; Result 4 and so on. My question is, if the fields for 'Result 2'
and 'Result 3' are empty, can I dynamically remove the ';' so that my results
read:- Result 1; Result4 instead of the results I am currently getting:-
Result 1; ; ; Result 4 I would appreciate any help on this one, as I can't
seem to find anything which can help. Cheers :confused;

[David Powers]

cp:fusion wrote:

> My question is, if the fields for 'Result 2'
> and 'Result 3' are empty, can I dynamically remove the ';' so that my results
> read:- Result 1; Result4

if (!empty($variable_that_contains_result)) {
echo $variable_that_contains_result.'; ';
}

The expression !empty() checks that the variable passed to it has a value.

If the result is empty, nothing will be displayed, thereby omitting the
redundant semicolon and following space.

--
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]

[cp:fusion]

Hi David, thanks for the reply, I am however struggling with the placement of
the code in my Dreamweaver generated PHP. Is there any chance you could let me
know where I should be putting your code in the following example:- Other:
<?php echo $row_rsCCAPsearch['Orig_Desig']; ?>; <?php echo
$row_rsCCAPsearch['Equiv_Strains']; ?>; <?php echo
$row_rsCCAPsearch['Other_Desigs']; ?>; <strong><?php echo
$row_rsCCAPsearch['Type_Culture']; ?></strong>; <?php echo
$row_rsCCAPsearch['Extra_Info_1']; ?>; <strong><?php echo
$row_rsCCAPsearch['Pathogen']; ?></strong>; FORM A MUST ACCOMPANY ORDER<br>
Many thanks in advance, Craig

[cp:fusion]

Hi David, thanks for the reply, I am however struggling with the placement of
the code in my Dreamweaver generated PHP. Is there any chance you could let me
know where I should be putting your code in the following example:- Other:
<?php echo $row_rsCCAPsearch['Orig_Desig']; ?>; <?php echo
$row_rsCCAPsearch['Equiv_Strains']; ?>; <?php echo
$row_rsCCAPsearch['Other_Desigs']; ?>; <strong><?php echo
$row_rsCCAPsearch['Type_Culture']; ?></strong>; <?php echo
$row_rsCCAPsearch['Extra_Info_1']; ?>; <strong><?php echo
$row_rsCCAPsearch['Pathogen']; ?></strong>; FORM A MUST ACCOMPANY ORDER<br>
Many thanks in advance, Craig

[David Powers]

cp:fusion wrote:

> Is there any chance you could let me
> know where I should be putting your code in the following example:- Other:
> <?php echo $row_rsCCAPsearch['Orig_Desig']; ?>; <?php echo
> $row_rsCCAPsearch['Equiv_Strains']; ?>;

<?php if (!empty($row_rsCCAPsearch['Orig_Desig']))
echo $row_rsCCAPsearch['Orig_Desig'].'; ';
if (!empty($row_rsCCAPsearch['Equiv_Strains']))
echo $row_rsCCAPsearch['Equiv_Strains'].'; ';

and so on.

--
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]

[cp:fusion]

Thanks very much for your help David, you are a star!

Craig

[Michael Fesser]

.oO(David Powers)

>cp:fusion wrote:

>> Is there any chance you could let me
>> know where I should be putting your code in the following example:- Other:
>> <?php echo $row_rsCCAPsearch['Orig_Desig']; ?>; <?php echo
>> $row_rsCCAPsearch['Equiv_Strains']; ?>;

>
><?php if (!empty($row_rsCCAPsearch['Orig_Desig']))
> echo $row_rsCCAPsearch['Orig_Desig'].'; ';
>if (!empty($row_rsCCAPsearch['Equiv_Strains']))
> echo $row_rsCCAPsearch['Equiv_Strains'].'; ';

It would probably be easier to loop through the record set ...

Micha

[David Powers]

Michael Fesser wrote:

> It would probably be easier to loop through the record set ...

I agree, but the original poster wanted to adapt DW-generated code, and
had difficulty in understanding how to apply !empty(). One step at a time...

--
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]