combo box value not display?

[selvasoft]

The php script did not retrieve the value from mysql database.
here i have color field in database.i want show that colors in my combo box
please find out my attachment.
if there any errors in following code.

<?php
$con=mysql_connect("localhost","root","red");
if(!$con)
{
   die('Not Connet Our Server'.mysql_error());
}
mysql_select_db("my_db",$con);
$result=mysql_query("select color from gallery");
echo "<select name='colors'>Shade Color</option>"; 
while($mycolor=mysql_fetch_array($result))
{
echo "<option value=" . $mycolor['id'] .">" . $mycolor['color'] .
echo "</option>";
}
mysql_close($con);
?>

[Atli]

Hey.

What is this printing, exactly?

The only problem I see there is that you left out the "id" field from the SQL query. You need to specify all columns you want it to return, so if you want to use the "id", you need to have the SQL query return that as well.

Also, you may want to add a "or die(mysql_error ())" after the mysql_query() call, so that you know if the query is failing.