When a field value is empty how do you not show it...

[phatnugs420]

Hi thanks for the help in advanced!.. To further explain what i want it to
do is:

go from:

Body Conscious
1815 Division St # 101
Nashville TN, 37203
615-321-8555
<blank field>
Touching Nashville since 1989, seven days a week.
to:

Body Conscious
1815 Division St # 101
Nashville TN, 37203
615-321-8555
Touching Nashville since 1989, seven days a week.

below is the code that I've been trying to work with:
<?php
$color1 = "#FFFFFF";
$color2 = "#FFFFCC";
$row_count = "0";

$query = mysql_query("SELECT DISTINCT * FROM itl WHERE city='$city2'
AND state='$state2' ORDER BY company") or die (mysql_error());
if (mysql_num_rows($query) < 1) { echo ''; }
while ($row = mysql_fetch_assoc($query)) {
$row_color = ($row_count % 2) ? $color1 : $color2;

?>
<tr>
<td width="400" bgcolor="<?php echo
$row_color; ?>"><ul>
<?php
echo('<font size="1" face="Verdana, Arial,
Helvetica,
sans-serif"><b>' . $row['company'] . '</b>' . '<br>' .
$row['address'] . '<br>' . $row['city'] . ' ' . $row['state'] . ', '
.. $row['zip'] . '<br>' . $row['phone'] . '<br>' . '<a href="http://'

.. $row['website'] . '">' . $row['website'] . '</a><br>' .

$row['description'] . '</font></li></p>');
?>
</ul></td>
</tr>
<?php
$row_count++;
}
}
?>

[C.J. Garibay]

ph*********@comcast.net wrote:

Hi thanks for the help in advanced!.. To further explain what i want it to
do is:

go from:

Body Conscious
1815 Division St # 101
Nashville TN, 37203
615-321-8555
<blank field>
Touching Nashville since 1989, seven days a week.
to:

Body Conscious
1815 Division St # 101
Nashville TN, 37203
615-321-8555
Touching Nashville since 1989, seven days a week.

below is the code that I've been trying to work with:
<?php
$color1 = "#FFFFFF";
$color2 = "#FFFFCC";
$row_count = "0";

$query = mysql_query("SELECT DISTINCT * FROM itl WHERE city='$city2'
AND state='$state2' ORDER BY company") or die (mysql_error());
if (mysql_num_rows($query) < 1) { echo ''; }
while ($row = mysql_fetch_assoc($query)) {
$row_color = ($row_count % 2) ? $color1 : $color2;

?>
<tr>
<td width="400" bgcolor="<?php echo
$row_color; ?>"><ul>
<?php
echo('<font size="1" face="Verdana, Arial,
Helvetica,
sans-serif"><b>' . $row['company'] . '</b>' . '<br>' .
$row['address'] . '<br>' . $row['city'] . ' ' . $row['state'] . ', '
. $row['zip'] . '<br>' . $row['phone'] . '<br>' . '<a href="http://'

. $row['website'] . '">' . $row['website'] . '</a><br>' .

$row['description'] . '</font></li></p>');
?>
</ul></td>
</tr>
<?php
$row_count++;
}
}
?>

Try something like this:

<?php
$color1 = "#FFFFFF";
$color2 = "#FFFFCC";
$row_count = "0";

$query = mysql_query("SELECT DISTINCT * FROM itl WHERE city='$city2'
AND state='$state2' ORDER BY company") or die (mysql_error());

if (mysql_num_rows($query) < 1) { exit; }

while ($row = mysql_fetch_assoc($query)) {
$row_color = ($row_count % 2) ? $color1 : $color2;
?>

<tr bgcolor="<?php echo $row_color; ?>">
<td width="400">
<font size="1" face="Verdana, Arial, Helvetica, sans-serif">

<?php
if ($row["company"] != "") { echo "<b>".$row["company"]."</b>" }
if ($row["address"] != "") { echo "<br>".$row["address"] }
if ($row["city"] != "") { echo "<br>".$row["city"] }
if ($row["state"] != "") { echo " ".$row["state"] }
if ($row["zip"] != "") { echo ", ".$row["zip"] }
if ($row["phone"] != "") { echo "<br>".$row["phone"] }
echo "<br>".'<a href="http://';
if ($row["website"] != "") { echo $row["website"].'">'.$row["website"] }
echo "</a>";
if ($row["description"] != "") { echo "<br>".$row["description"] }
?>

</font>
</td>
</tr>

<?php
$row_count++;
}
?>

[Chung Leong]

<ph*********@comcast.net> wrote in message
news:BD440097.719A%ph*********@comcast.net...

Hi thanks for the help in advanced!.. To further explain what i want it to
do is:

go from:

Body Conscious
1815 Division St # 101
Nashville TN, 37203
615-321-8555
<blank field>
Touching Nashville since 1989, seven days a week.
to:

Body Conscious
1815 Division St # 101
Nashville TN, 37203
615-321-8555
Touching Nashville since 1989, seven days a week.

below is the code that I've been trying to work with:
<?php
$color1 = "#FFFFFF";
$color2 = "#FFFFCC";
$row_count = "0";

$query = mysql_query("SELECT DISTINCT * FROM itl WHERE city='$city2'
AND state='$state2' ORDER BY company") or die (mysql_error());
if (mysql_num_rows($query) < 1) { echo ''; }
while ($row = mysql_fetch_assoc($query)) {
$row_color = ($row_count % 2) ? $color1 : $color2;

?>
<tr>
<td width="400" bgcolor="<?php echo
$row_color; ?>"><ul>
<?php
echo('<font size="1" face="Verdana, Arial, Helvetica,
sans-serif"><b>' . $row['company'] . '</b>' . '<br>' .
$row['address'] . '<br>' . $row['city'] . ' ' . $row['state'] . ', '
. $row['zip'] . '<br>' . $row['phone'] . '<br>' . '<a href="http://'

. $row['website'] . '">' . $row['website'] . '</a><br>' .

$row['description'] . '</font></li></p>');
?>
</ul></td>
</tr>
<?php
$row_count++;
}
}
?>

For situation like this I like to stick the variables into an array, run it
through array_filter(), then either loop through it or hand it to implode().