MySQL PHP - How to remove unnecessary php echo text when mysql field is null?

Question

I've got a client who wants me to format a list of businesses on a website page using data from a mysql database and putting it on the web page using php.

The client wants each piece of data to be identified, like this:

Contact Person: Sue Smith
Website: greatwebsite.com

Here's the problem:

Some of the businesses don't have a website. So I do NOT want the business listing to show up like this:

Contact Person: Sue Smith
Website:

I do NOT want the Website line to show up at all if there is no website.

Here's what I've done so far - which does NOT solve the problem (truncated for brevity):

$result = mysql_query("SELECT * FROM businesses ORDER BY business");
while($field = mysql_fetch_array($result))
{
    echo
    "<h3>".$field['business']."</h3>
    <p>Website: ".$field['website']."</p>";
}

I need to learn how to delete the "Website" line entirely if there is no website.

Aurelio De Rosa · Accepted Answer · 2011-11-01 21:17:23Z

5

A simple if will work fine:

$result = mysql_query("SELECT * FROM businesses ORDER BY business");
while($field = mysql_fetch_array($result))
{
   if (! empty($field['business']) )
      echo "<h3>".$field['business']."</h3>";

   if (! empty($field['website']) )
      echo "<p>Website: ".$field['website']."</p>";
}

answered Nov 1, 2011 at 21:17

Aurelio De Rosa

22.2k8 gold badges51 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Yes Barry Over a year ago

empty() is the function you were looking for.

Kip Shaw Over a year ago

To all who answered me promptly, I offer a grateful THANKS! To you who are further along, you have helped a newbie immensely. This is what makes this Internet community so powerful. Again, thanks.

Aurelio De Rosa Over a year ago

@KipShaw I'm very glad to help person like you. Keep it up! ;)

Zoltan Toth · Accepted Answer · 2011-11-01 21:18:50Z

1

while($field = mysql_fetch_array($result))
{
    echo "<h3>".$field['business']."</h3>";
    if ($field['website'] != '') {
        echo "<p>Website: ".$field['website']."</p>";
    }
}

answered Nov 1, 2011 at 21:18

Zoltan Toth

47.8k12 gold badges132 silver badges138 bronze badges

Comments

Polynomial · Accepted Answer · 2011-11-01 21:18:52Z

0

$result = mysql_query("SELECT * FROM businesses ORDER BY business");
while($field = mysql_fetch_array($result))
{
    echo "<h3>".$field['business']."</h3>";
    if(!empty($field['website']))
        <p>Website: ".$field['website']."</p>";
}

answered Nov 1, 2011 at 21:18

Polynomial

28.4k13 gold badges86 silver badges110 bronze badges

Collectives™ on Stack Overflow

MySQL PHP - How to remove unnecessary php echo text when mysql field is null?

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related