[SOLVED] combo box and sql in php

[ali_2kool2002]

hi can any1 give an example of a query being called from a database in sql and the result being stored in a combo box in php?

 

thanks for anyone who can help...

The code for a normal combo box sending the value as item is show below but i want the options to be from specifically in the databse.

<select name="item"> 
<option>Paint</option>
<option>Brushes</option>
<option>Erasers</option>
<?php
$_POST['item'];
?>

[craygo]

<?php
echo "<select name=item>\n";
$sql = "SELECT id, item FROM items ORDER BY item ASC";
$res = mysql_query($res) or die(mysql_error());
while($r=mysql_fetch_assoc($res)){
echo "<option value='".$r['id']."'>".$r['item']."</option>\n";
}
echo "</select>\n";
?>

 

Ray

 

[ali_2kool2002]

thanks ray!! nice 1 ,, and the other guy! good stuff! much appreciated!  8)