drop down list recent value

[Anon]

Hi,

I managed to get a drop downlist which get the values out of a other table with a select query.
Now i want to have an edit screen but i don't get the value wich is stored in the database

this is the code

<select name="cnaam" size=1>
<?php
mysql_connect ("localhost","root","");
mysql_select_db ("emis");
$query = "select cnaam, cnaam from companies1 order by cnaam";
$result = mysql_query($query);
while($cn = mysql_fetch_array($result))
{
print("<option value=\"$cn[0]\">$cn[1]\n");
}

?>

how do i edit it to get it to work on a edit screen?

thanks for your help

[Anon]

Fetch_array creates an associative array.

You want to use mysql_fetch_row()

Cheers

Justin