[Abrica]

Hi,
I have a div tag which echos text from a mySQL database, the div has a red background (in the CSS) the problem is, when there is not text in the databse, it still shows an empty red background.
The CSS for the div is:

Code:

#alertnews {color:#C00;font-weight:bold;font-size:16px;background-color:#FFCECE;padding-left:3px;padding-top:3px;padding-right:3px;padding-bottom:3px}

and the tag is like this:

PHP Code:

<div id="alertnews">

          <? while ($row_settings = mysql_fetch_array($rs_settings)) {?>

          <? echo $row_settings['alertnews']; ?>

          <? } ?>

        </div>

Anyone know code that will remove the div if its empty?

Thanks a lot!

[DanielVS]

How about this:

Code:

<? if (mysql_num_rows($rs_settings)) { ?>
   <div id="alertnews">
      <? while ($row_settings = mysql_fetch_array($rs_settings)) {?>
         <? echo $row_settings['alertnews']; ?>
      <? } ?>
   </div>
<? } ?>