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.

score 6 · Accepted Answer · answered Nov 01 '11 at 21:17

6

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 01 '11 at 21:17

Aurelio De Rosa

21,856
8
48
71

1

empty() is the function you were looking for. – Yes Barry Nov 01 '11 at 21:18
1

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. – Kip Shaw Nov 01 '11 at 23:31
1

@KipShaw I'm very glad to help person like you. Keep it up! ;) – Aurelio De Rosa Nov 01 '11 at 23:57

score 1 · Answer 2 · answered Nov 01 '11 at 21:18

1

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

answered Nov 01 '11 at 21:18

Zoltan Toth

46,981
12
120
134

score 0 · Answer 3 · answered Nov 01 '11 at 21:18

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 01 '11 at 21:18

Polynomial

27,674
12
80
107

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

3 Answers3