If Empty Do Not Echo?

PHP
1

Hi,

I have a simple echo code which echoes everything in 3 rows. However it also echoes empty values. Can anyone advise how I can prevent the empty cells in the databsae from being echoed?

So for example if one user only submits 1 skill and another user submits 3 skills. It will echo the 1 skills and 2 empty spaces and then the 3 skills from the second user.

<div class="eventskillsbox">
				<?php
$query = mysql_query("SELECT skill1, skill2, skill3
FROM users ");	
while($row = mysql_fetch_array($query)) {
?>
<div class="eventskillscell">
<?php echo $row['skill1']; ?>
</div>
<div class="eventskillscell">
<?php echo $row['skill2']; ?>
</div>
<div class="eventskillscell">
<?php echo $row['skill3']; ?>
</div>

<?php
}
?>
	</div>
2

See http://www.sitepoint.com/forums/showthread.php?937211-If-Blank-Do-Not-Echo&highlight=empty

3

Thanks mate,

I am trying to use that but it doesn’t seem to be working. Do I simply change it to this?

<div class="eventskillsbox">
				<?php
$query = mysql_query("SELECT skill1, skill2, skill3
FROM users ");	
while($row = mysql_fetch_array($query)) {
?>
<div class="eventskillscell">
<?php echo (!empty($row['skill1'])) ? $row['skill1'] : ''; ?>
</div>
<div class="eventskillscell">
<?php echo (!empty($row['skill2'])) ? $row['skill2'] : ''; ?>
</div>
<div class="eventskillscell">
<?php echo (!empty($row['skill3'])) ? $row['skill3'] : ''; ?>
</div>

<?php
}
?>
	</div>
4

That is one way, another would be:

<div class="eventskillsbox">
				<?php
$query = mysql_query("SELECT skill1, skill2, skill3
FROM users ");	
while($row = mysql_fetch_array($query)) {
?>
<?php if (!empty($row['skill1'])) : ?>
<div class="eventskillscell">
<?php echo $row['skill1'] ; ?>
</div>
<?php endif; ?>
<?php if (!empty($row['skill2'])) : ?>
<div class="eventskillscell">
<?php echo $row['skill2'] ; ?>
</div>
<?php endif; ?>
<?php if (!empty($row['skill3'])) : ?>
<div class="eventskillscell">
<?php echo $row['skill3'] ; ?>
</div>
<?php endif; ?>

<?php
}
?>
	</div>
5

Cheers matey, this one worked fine.