Dropdown in php

[ruth Gammack]

i am trying to use a drop down in php based on the results i returned in the query. at the moment i have three items in my database so the form is displaying correctly bu the drop down option is not. it returns $row['$results']

<?php
  $sql = "SELECT moduleID FROM module";
 
                    $stmt = $conn->prepare($sql);
                try {
                    $stmt->execute();
                    $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
 
                    if (!$results){ // check we have some results
                        echo "No modules Available to rank <br />";
                    }
                    else{    //generate form
 
                        foreach ($results as $row){
 
                        ?>
                           <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" >
                            <label for="search">Rate:</label>
                            <select name"modIDDropdown" value="moduleID">
                             echo "<option>$row['$results']</option>"
                            </select>
                            <input type="submit" name="submit" id="submit" />
                               </form>
                               <?php
                        }
 
                    }
                } catch ( PDOException $e ) {
                    echo "Query failed: " . $e->getMessage();
                }
?>

[omerbutt]

hi
chnage

echo "<option>$row['$results']</option>"

to the following as you are returning the assoc array

echo "<option>".$row['NAME_OF_THE_TABLE_FIELD']."</option>";
 

regards,
Omer Aslam

[ruth Gammack]

I have tried this and in the box i get ".$row['moduleID']."

Regards Ruth

[johny10151981]

I dont see any thing right in your select object.

<select name"modIDDropdown" value="moduleID">
echo "<option>$row['$results']</option>"
</select>
 

rewrite it according below:

<select name="modIDDropdown" >
<?php
echo "<option value='".$row[$results]."'>".$row[$results]."</option>";
?>
</select>
 

[ruth Gammack]

thank you as this work now but i would like all the drop downs to contain all the same values. for example there is now three modules and i want to rank them so i would want all three values in each drop down how to i go about that?

[johny10151981]

please read the documentation about drop down searching on google