value of option menu not showing.

[unistake]

Something is wrong with this drop down form menu.

 

The name of the option appears and works well however the value does not seem to work.

 

Any ideas?

 

Thanks

 

<?php 
                    include("cxn.php");
                    
                    $query = "SELECT manufacturer FROM list ORDER BY manufacturer ASC"; 
                    $result = mysqli_query($cxn,$query) or die(mysqli_error());
                     
                    ?>
                    <select name="manufacturer" id="manufacturer">
                       <option value="" selected="selected">Select a Manufacturer..</option>";
                    <?php 
                    while($row = mysqli_fetch_row($result)){
                          echo "<option value=\"".$row[0]."\">".$row[0]."</option>"; // SHOWS ALL MANUFACTURERS CURRENTLY ADVERTISED WITH THE NUMBER OF ADVERTS NEXT TO THE MANUFACTURER
                       }
                    ?>

[benji_182]

Hmmm, personally I'd try it like this.

 

<?php                     
include("cxn.php");                                        

$query = "SELECT manufacturer FROM list ORDER BY manufacturer ASC";                     
$result = mysqli_query($cxn,$query) or die(mysqli_error());                                         ?>                    

<select name="manufacturer" id="manufacturer">                       
<option value="" selected="selected">Select a Manufacturer..</option>";                    

<?php

while ($row = mysqli_fetch_row($result))
{                          
          echo "<option value=\"{$row["fieldname1"]}\">{$row["fieldname2"]}</option>"; 
}                    
?>
</select>

 

Hope this helps.

[Colton.Wagner]

You did not echo the <select> tag or the first <option> or the closing </select> tag.

Revised code:

 

<?php 
                    include("cxn.php");
                    
                    $query = "SELECT manufacturer FROM list ORDER BY manufacturer ASC"; 
                    $result = mysqli_query($cxn,$query) or die(mysqli_error());
                
                    echo "<select name=\"manufacturer\" id=\"manufacturer\">";
                       echo "<option value=\"\" selected=\"selected\">Select a Manufacturer..</option>";

                    while($row = mysqli_fetch_row($result)){
                          echo "<option value=\"".$row[0]."\">".$row[0]."</option>"; // SHOWS ALL MANUFACTURERS CURRENTLY ADVERTISED WITH THE NUMBER OF ADVERTS NEXT TO THE MANUFACTURER
                       }
                      echo "</select>";
                    ?>

[unistake]

they are there in between the two php scripts. (in black above)