[RESOLVED] How do I get data from mysql and list them in a form with a dropdown menu?

[Wales]

I want to get a list of categories from mysql:

$categories = 'SELECT * FROM categories ORDER BY name ASC';

and have it listed in a form something like:

<form action="category.php" method="post">
<select>
  <option>from categories go here</option>
  <option>from categories go here</option>
</select>
</form>

Once I select the options from the category section post that option in a different databse.

[sheephat]

something like this i do believe:

<?php 

$conn = mysql_query("SELECT * FROM categories ORDER BY name ASC") ;?>
<form action="category.php" method="post">
<select>
<?php
while($whileloop = mysql_fetch_array($conn))
{?>
<option><?php echo $whileloop['fieldid']; ?></option>
<?php
}?>
</select>
</form>

[Wales]

Works perfectly! Thanks.

[sheephat]

Glad i could help

Make sure you mark the thread as resolved.