[SOLVED] SQL query that doesn't print empty rows

[freelancer]

Hello! Need some assistance here.

 

I have table like this

 

name, age
john, 24
phil

 

And PHP code

 

while($row = mysql_fetch_array($result ))
{
   echo "Name: ";
   echo $row['name'];
   echo "<br>";
   echo "Age: ";
   echo $row['age'];
   echo "<br>";
}

 

That prints all results as following:

 

Name: John

Age: 24

 

Name: Phil

Age:

 

How to make this happen that if there is no age in database then age row will not be displayed like so my display results should be only like this according to my data:

 

Name: John

Age: 24

 

Name: Phil

 

 

Hope you understood Thanks!

 

[mrMarcus]

<?php
while ($row = mysql_fetch_array ($result))
{
if (!empty ($row['age']))
{
	echo "Name: ";
	echo $row['name'];
	echo "<br>";
	echo "Age: ";
	echo $row['age'];
	echo "<br>";
}
}
?>

[Bricktop]

Hi Phil,

 

You could do:

 

while($row = mysql_fetch_array($result ))
{
   echo "Name: ";
   echo $row['name'];
   echo "<br>";
   if(!empty $row['age'])
   {
   echo "Age: ";
   echo $row['age'];
   echo "<br>";
   }
}

 

mrMarcus' solution will not print the name if the age is empty.

 

Hope this helps.

[Maq]

while ($row = mysql_fetch_array ($result))
{
if (!empty ($row['age']))
{
	echo "Name: ";
	echo $row['name'];
	echo "
";
	echo "Age: ";
	echo $row['age'];
	echo "
";
}
}
?>

 

mrMarcus, if you're going to do that, which is not what the OP wants, than you mine as well use MySQL and use a WHERE clause to check for empty age values.

 

I don't think you can accomplish this with MySQL, but if you can that would be better.  Anyway, just check if the 'age' is blank.

 

   echo ($row['age']=="") ? "" : "Age: {$row['age']} 
";

[mrMarcus]

<?php
while ($row = mysql_fetch_array ($result))
{
if (!empty ($row['age']))
{
	echo "Name: ";
	echo $row['name'];
	echo "<br>";
	echo "Age: ";
	echo $row['age'];
	echo "<br>";
}
}
?>

 

mrMarcus, if you're going to do that, which is not what the OP wants, than you mine as well use MySQL and use a WHERE clause to check for empty age values.

 

I don't think you can accomplish this with MySQL, but if you can that would be better.  Anyway, just check if the 'age' is blank.

 

   echo ($row['age']=="") ? "" : "Age: {$row['age']} <br>";

thing is, i never seem to be quite sure what the OP wants :S

 

what you put was actually my original thought .. mistook (is that a word?) just dropping the age while keeping the name, for dropping the entire row on an empty 'age' field.

[freelancer]

Thanks you Got it now!

[Maq]

thing is, i never seem to be quite sure what the OP wants :S

 

Don't worry, me either.