hiding certain elements

[Dillenger]

I cannot figure this out for the life of me 🙁:

I'm trying to have a list from a database, that displays as such

Item 1:
a
b
c
Item 2:
a
Item 3:
Item 4:
Item 5:
a
b

I would like to have it so that the items without content (ie. item 4 and 5) are hidden until content is entered into them.

Here is the code I have setup to make this happen, but I cannot figure out how to hide the ones with nothing in them, can anyone help me?

<?

$sql = "select * from areas ORDER BY id ASC";

$result = mysql_query($sql);

while ($owners = mysql_fetch_array($result)) {

$id=$owners['id'];
$area1=$owners['name'];

echo "<tr><td colspan=\"5\" valign=\"top\"><span class=\"headers\">$area1</span></td></tr>";

$sql2 = "select * from southpermits_data WHERE area = '$area1'";

$result2 = mysql_query($sql2);

while ($south = mysql_fetch_array($result2)) {

$id=$south['id'];
$date=$south['date'];
$area =$south['area'];
$owner =$south['owner'];
$owner_address =$south['owner_address'];
$owner_city =$south['owner_city'];
$owner_postalcode1 =$south['owner_postalcode1'];
$owner_postalcode2 =$south['owner_postalcode2'];
$owner_phonenumber1 =$south['owner_phonenumber1'];
$owner_phonenumber2 =$south['owner_phonenumber2'];
$owner_phonenumber3 =$south['owner_phonenumber3'];
$project_address =$south['project_address'];
$project_type=$south['project_type'];
$project_type2=$south['project_type2'];
$amount =$south['amount'];
$contractor =$south['contractor'];
$contractor_address =$south['contractor_address'];
$contractor_city =$south['contractor_city'];
$contractor_postalcode1 =$south['contractor_postalcode1'];
$contractor_postalcode2 =$south['contractor_postalcode2'];
$contractor_phonenumber1=$south['contractor_phonenumber1'];
$contractor_phonenumber2=$south['contractor_phonenumber2'];
$contractor_phonenumber3=$south['contractor_phonenumber3'];
$published=$south['published'];



echo "<a href=\"south_permits.php?id=$id&task=edit\"><tr onMouseOver=\"this.className='over'\" onMouseOut=\"this.className='out'\" class=\"out\">";
echo "            <td valign=\"top\">$owner<br>$owner_address $owner_city <span class=postal>$owner_postalcode1-$owner_postalcode2</span></td>";
echo "            <td valign=\"top\">$project_address</td>";
echo "            <td valign=\"top\">$project_type<br>$project_type2</td>";
echo "            <td valign=\"top\">";

if ($amount == "n/a"){
echo "$amount";
}else if(eregi("m", $amount)) {
echo "\$$amount";
}else{
echo "\$$amount,000";
}

echo"</td>";
echo "            <td valign=\"top\">$contractor<br>$contractor_address $contractor_city ";

if ($contractor_postalcode1 == ""){
echo "";
}else{
echo "<span class=postal>$contractor_postalcode1-$contractor_postalcode2</span>";
}


echo "</td></tr></a>";

}

}

?>

[LordShryku]

Well, your code is definatly doing more than "Item1", "Item2"....

I assume you meant this part?

if ($contractor_postalcode1 == ""){
echo "";
}else{
echo "<span class=postal>$contractor_postalcode1-$contractor_postalcode2</span>";
} 

First, you may want to use [man]empty[/man] to check it. Because a NULL value != "". Second, no need to echo if it is empty...

if(!empty($contractor_postalcode1)) {
   echo "<span class=postal>$contractor_postalcode1-$contractor_postalcode2</span>";
} 

[Dillenger]

thanks for that answer, but i'm really talking about matching area1 with area, and if they don't match, then don't display area1 at all...

[LordShryku]

I see. So move the first echo down and check the amount of rows returned before your while statement.

$result2 = mysql_query($sql2); 
if(mysql_num_rows($result2) > 0) {
   echo "<tr><td colspan=\"5\" valign=\"top\"><span class=\"headers\">$area1</span></td></tr>";
   while ($south = mysql_fetch_array($result2)) { 
      // show all the detail
   }
}

[Dillenger]

tried that, but the problem is area1 is in a different table than area... so cant really match them that way, i was thinking about doing an eregi... like if eregi(area1, area) {

but i can't get that to want to work either.

I'm not trying to just show/hide all the detail, i'm wanting to not show area1 if there is no detail...