IF statement Help

[syclonefx]

My IF statement isn't working. Everything below the if statement comes up. Can some one help me with this problem?

 

<?php
$bizID = ($row_rsBizCat['bizID']); 
$query = sprintf("SELECT * FROM rsbiz WHERE active = 1 AND bizID = %s",mysql_real_escape_string($bizID));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
if ($row['biztype'] =="web") {
echo '<span class="dtblk"><a href="services_details.php?bizID=' . $row['bizID'] . '" class="outlnk" title="' .$row['name']. '">' .$row['name']. '</a></span><br />'; }
if ($row['biztype'] =="biz") {
echo '<span class="dtblk"><a href="services_details.php?bizID=' . $row['bizID'] . '" class="outlnk" title="' .$row['name']. '">' .$row['name']. '</a></span><br />'; }
echo '<span>Address: ' . $row['address'] . '</span><br />';
echo '<span>City: ' . $row['city'] . '</span><br />';
echo '<span>State: ' . $row['state'] . '</span><br />';
echo '<span>Zip Code: ' . $row['zipcode'] . '</span><br />';
echo '<span>Phone: ' . $row['phone'] . '</span>';
} ?>

 

[kenrbnsn]

I'm not sure what you mean by:

Everything below the if statement comes up.

There are two "if" statements.

 

I don't see any difference in what you're echoing in the two "if" statements, so you should be able to combine them

<?php
$bizID = ($row_rsBizCat['bizID']); 
$query = sprintf("SELECT * FROM rsbiz WHERE active = 1 AND bizID = %s",mysql_real_escape_string($bizID));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
      if ($row['biztype'] =="web" || $row['biztype'] == 'biz')
            echo '<span class="dtblk"><a href="services_details.php?bizID=' . $row['bizID'] . '" class="outlnk" title="' .$row['name']. '">' .$row['name']. '</a></span><br />';
      echo '<span>Address: ' . $row['address'] . '</span><br />';
      echo '<span>City: ' . $row['city'] . '</span><br />';
      echo '<span>State: ' . $row['state'] . '</span><br />';
      echo '<span>Zip Code: ' . $row['zipcode'] . '</span><br />';
      echo '<span>Phone: ' . $row['phone'] . '</span>';
} ?>

 

Ken

[syclonefx]

Thanks for the Help!!