blank field

[wazo]

Hi guys

What I want to do is when I fill my dropdown box to skip the sublocation boxes
which are empty how can i do this

cat_id :Avon
sublocation :Bath
sublocationshow:Bath

cat_id :Avon
sublocation :
sublocationshow:All Avon Sub Locations

    <select id="sublocation" name="sublocation">
        
  <option value="">Sub Location</option>

  <?
while($noticia3 = mysql_fetch_array($quer2)) { 


if($noticia3['sublocation']==$sublocation){echo "<option selected value='$noticia3[sublocation]'>$noticia3[sublocationshow]</option>"."<br />";}

else{echo  " <option value='$noticia3[sublocation]'>$noticia3[sublocationshow]</option>";}

}
?>

        </select>

[guelphdad]

this isn't a mysql question, you want to have this answered in the php forum. ask a moderator to move your question.

[Dan Grossman]

<select id="sublocation" name="sublocation">
<option value="">Sub Location</option>

<?php

while($noticia3 = mysql_fetch_array($quer2)) { 

  if ($noticia3['sublocation'] == $sublocation) {
    echo "<option selected value='$noticia3[sublocation]'>$noticia3[sublocationshow]</option><br />";
  } elseif (!empty($noticia3['sublocation'])) {
    echo "<option value='$noticia3[sublocation]'>$noticia3[sublocationshow]</option>";
  }

}
?>

</select>