[SOLVED] Dynamically Generated Combo Box Problem

[Bopo]

Hi

 

Well I don't think its too serious, but when I click my combo box to view the list options, only blank spaces appear, around 5 lines appear which is the amount of data I'm pulling back, therefore I believe it's there, I just can't see it, below is the code.

 

<?php

include("blogconnect.php");

     echo "<select name=\"categorychosen\">";
     $sql = "SELECT * FROM cat ORDER BY category DESC";
     echo "<option value=\"\">Select a category</option>";
 $query = mysql_query($sql, $connect);
    while($row = mysql_fetch_assoc($query)){
       echo "<option value=\"".$row['category']."\"></option>";
    }
     echo "</select>";
?>

 

Just checked the HTML, the options are there, but there appearing as <option value="Wildlife"></option> etc.

[Yesideez]

The problem is that you're not inserting anything between the tags.

echo '<option value="'.$row['category'].'">'.$row['category'].'</option>';

[Bopo]

Totally correct, thanks