How can i display a columns values from my database as selections for my drop down menu?

Question

How can i display a columns values from my database in a drop down menu as selections? So far I have the forms code down I think now I'm trying to figure out the actual database code side of this. Any help is greatly appreciated. Thanks in advance.

This may help:

http://oi61.tinypic.com/258tmhd.jpg

CODE

<html>
<header>



</header>

<body>

<form action="/demoform/contact_form.php" id="formA" method="post" name="formA">

<big>LOAD PAST ORDERS:</big>

<select id="drop_down" name="drop_down">
   <?php foreach($array_results as $row) : ?>
       <option value="<?php echo $row['key'];?>" ><?php echo $row['itemname'];</option>
   <?php endforeach; ?>
</select>



<input type="text" id="email" name="email"/>



<input id="email" name="email" type="text"   value="demo@gmail.com" readonly="readonly"/>


<input id="itemname" name="itemname" type="text" />



<button type="submit" value="Submit">Submit</button>


</form>


</body>


</html>

possible duplicate of [Get table column names in mysql?](http://stackoverflow.com/questions/1526688/get-table-column-names-in-mysql) — maiorano84, Jan 08 '15 at 00:22
I am not vary clear about your question. Are you trying find the database query to get itemname filtered by email address ? — Choudhury A. M., Jan 08 '15 at 00:26
`SELECT \`key\`, itemname FROM table_name WHERE email = ?` with the email address being the parameter. — prodigitalson, Jan 08 '15 at 00:32

score 0 · Answer 1 · answered Jan 08 '15 at 00:38

If you use PHP mysqli OOP this is hopefully helpful:

while($row = $result->fetch_array()) {
 echo("<option value=\"" . $row["key"] . "\">" . $row["itemname"] . "</option>\n");
}

To fill the input text field with the value of the dropdown you can use jQuery:

<script type="text/javascript">
$("#idOfDropDown").change(function() {
 $("#idOfTextField").val( $("#idOfDropDown option:selected").val() );
});
</script>

How can i display a columns values from my database as selections for my drop down menu?

CODE

1 Answers1