[boskyvora]

Hi there,

I have a php page wherein when the page is loaded it should fetch records from the database and add the records in a combo-box.

Getting the record is not a problem but just assigning the value to the combo-box is giving me a tough time. Any guesses how it can be done.

Regards
Bosky

[nd2]

yeah, ive wrote a small php program below, just put your combo list entrys in the $mycombolist array and the result value of the field store in the variable $myvalue or rename that variable to the value of your out put, this will then select the field that it matchs.
have fun.

PHP Code:

<?php

// untested



$mycombolist = array(

"selectboxname" => "selectboxvalue",

"selectboxname2" => "selectboxvalue2"

);



?>

<select size="1" name="D1">



<?php



foreach (array_keys($mycombolist) as $i) {

// matched

if ($mycombolist[$i] == $myvalue) {

echo '<option selected value="'.$mycombolist[$i].'">'.$i.'</option>';

}



// didnt match

else {

echo '<option value="'.$mycombolist[$i].'">'.$i.'</option>';

}



}

?>

[ChristGuy]

I'm guessing you're looking for something like:

PHP Code:

  $Result = MySQL_DB_Query("DBName", "SELECT * FROM Clients");



  echo "<SELECT NAME='clientid'>";



  while ($Row = MySQL_Fetch_Array($Result))

  {

    echo "<OPTION VALUE='" . $Row["ClientID"] . "'>" . $Row["ClientName"] . "</OPTION>";

  }



  echo "</SELECT>";



  MySQL_Free_Result($Result); 

[sldghmr]

I've used the below script to populate my drop down box. What I'd like to do is have my page (which upon opening has all the fields blank) and then populate all the fields based on the selection made from the drop down box. So, I guess the question is how to pass that onto the rest of the form. Am I on the right track with this or is there a different way I should be doing it?

TIA
Ray

PHP Code:

$Result = MySQL_DB_Query("DBName", "SELECT * FROM Clients");



  echo "<SELECT NAME='clientid'>";



  while ($Row = MySQL_Fetch_Array($Result))

  {

    echo "<OPTION VALUE='" . $Row["ClientID"] . "'>" . $Row["ClientName"] . "</OPTION>";

  }



  echo "</SELECT>";



  MySQL_Free_Result($Result);