Selection in a dropdown box

[rasmas]

Hi All

I have retrieve data from a mysql database into a form. I amend the details and the update the database with the new information

In the form I have a number of dorpdown forms that are populated by retrieving info from the data base.

I need the dropdown to display the selection that was made and stored in the database

here is how I create the dropdowns

// supplier
$resultsp = mysql_query("SELECT ACCNO,ACTYPE,NAME,ACTIVE,EXCODE FROM fin_accounts where ACTIVE='Y' and ACTYPE='C' and EXCODE>'00' ");
			while ($rowsp = mysql_fetch_array($resultsp))
			{
$d_supplier .="<option value =".$rowsp['ACCNO'].">".$rowsp['NAME']."</option>\n";		
			}

//create form
$form_po_edit ="<form action=\"$self\" method=\"post\">";
$form_po_edit .="<table border=\"1\" cellpadding=\"2\" width = \"600\">";
$form_po_edit .="<TR>";
$form_po_edit .="<TD width = \"250\">Supplier </TD><TD width = \"350\">
<select name=\"supplier_code\">
echo($d_supplier)					
</select></TD>";
$form_po_edit .="</TR>";
$form_po_edit .= "</table>";
$form_po_edit .="<BR>";
$form_po_edit .="<input type=\"submit\" value=\"Submit\">";
$form_po_edit .="</form>";

echo ($form_po_edit);

This is just and extract of one of the drop downs, I have 20 fields and 5 dropdowns in the form

Thanks for the help
Martin

[Jasp182]

I always use an array of values to populate my combo boxes and build the options with a foreach() loop. The array contains all possible values, and I do a check on each iteration if the current value matches the selected value. If so, enter the text "selected" in the option tag.

Does this answer your question at all?

[AvisSoft]

Hi,

You can also use a if thing:

while ($rowsp = mysql_fetch_array($resultsp)) 
{ 
     if ($rowsp['ACCON'] == '123')
     {
          $d_supplier .="<option value =".$rowsp['ACCNO']." selected>".$rowsp['NAME']."</option>\n";
     }
     else
     {
          $d_supplier .="<option value =".$rowsp['ACCNO'].">".$rowsp['NAME']."</option>\n";
     }
}

Hope it helps.

Thanks.

[rasmas]

Thanks I will try both as soon as I have a chance,

Thanks