Re: İnsert into drop down menu item from mysql db's table

[Peter Brawley]

Something like ...

// QUERY TO POPULATE LIST FROM FIRST COLUMN OF A QUERY
$result = mysql_query( "SELECT somevalue FROM ..." );

// EXISTING OR PRESET VALUE IF ANY
$var = "some preconfigured value";

// FORM POSTS TO URL
echo "<FORM name='XXX' action='URL' method='POST'>\n";
echo " <b>PROMPT TEXT:</b>&nbsp;\n <SELECT name='varname' onChange='submit()'>\n";
while( $row = mysql_fetch_row( $result )) {
$sel = ( $var === $row[0] ) ? "id='sel' selected" : "";
printf( " <option %s value='%s'>%s</option>\n", $sel, $row[0], $row[0] );
}
echo " </SELECT>\n";

PB