test for empty data fields

dcjones

Hi all,

I want to output the data from a table. The table has the following fields:

address1
address2
address3
address4
address5

If "address2" is empty I do not want the field to appear in the output.

What I have so far is:

 <?php 
 $row = mysql_fetch_array($query_accomm_counties);     

 if (strlen ($row_accomm_counties['address1']) > 0)  { 
 echo $row_accomm_counties['address1']; 
 }
 ?>

<?php 
 $row = mysql_fetch_array($query_accomm_counties);     

 if (strlen ($row_accomm_counties['address2']) > 0)  { 
 echo $row_accomm_counties['address2']; 
 }
 ?>

I am testing for the empty field but how do I force the filed not to be displayed.

Can anyone advice please.

Many thank in advance

devinemke

$result = mysql_query('SELECT * FROM addresses') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	foreach ($row as $key => $value)
	{
		if ($value) {echo $key . ' = ' . $value . '<br>';}
	}
	echo '<br><br>';
}

dcjones

Hi divinmike,

Thanks for your reply.

This is what I have so far.

mysql_select_db($database_accomm, $accomm);
$query_accomm_counties = sprintf("SELECT * FROM accom WHERE name = '%s' ORDER BY pic DESC", $colname_accomm_counties);
$query_limit_accomm_counties = sprintf("%s LIMIT %d, %d", $query_accomm_counties, $startRow_accomm_counties, $maxRows_accomm_counties);
$accomm_counties = mysql_query($query_limit_accomm_counties, $accomm) or die(mysql_error());
$row_accomm_counties = mysql_fetch_assoc($accomm_counties);

Then lots of html.....

The screen output is:

<?php echo $row_accomm_counties['address1]; ?>

</span></td>

The code you posted, where do I place it with regard to the above.

Thanks again

dcjones

Hi again,

Can anyone help wit this post.