How to create a dynamic drop down box

I have created a php form with dynamic drop down boxes in it which pull the options from a database. The boxes work fine and the data gets submitted fine but im having a problem getting the box to default to a record of my choice from the database. (record 1 = None).
Here is the code to what i have done.

Expand|Select|Wrap|Line Numbers

 
<input maxLength="40" size="30" name="name"></td>

    </tr>

    <tr>

      <td width="286" height="22"><b>Person Involved:</b></td>

      <td align="left" width="365" height="24"><select name="person_involved">
 
        <?php

Expand|Select|Wrap|Line Numbers

 
hesk_dbConnect();

$sql = "SELECT * FROM `hesk_involved` ORDER BY `name` ASC";

$result = hesk_dbQuery($sql);

while ($row=hesk_dbFetchAssoc($result))

{

    echo "

    <option value=\"$row[name]\">$row[name]</option>

    ";

}

Expand|Select|Wrap|Line Numbers

 
?>

      </select></td>

    </tr>

Hope you guys can help me out as im pulling my hair out now.

Oct 1 '07 #1

Subscribe Post Reply

8250

nathj

938

Expert 512MB

I have created a php form with dynamic drop down boxes in it which pull the options from a database. The boxes work fine and the data gets submitted fine but im having a problem getting the box to default to a record of my choice from the database. (record 1 = None).
Here is the code to what i have done.
[php]
<input maxLength="40" size="30" name="name"></td>
</tr>
<tr>
<td width="286" height="22"><b>Person Involved:</b></td>
<td align="left" width="365" height="24"><select name="person_involved">

<?php

hesk_dbConnect();
$sql = "SELECT * FROM `hesk_involved` ORDER BY `name` ASC";
$result = hesk_dbQuery($sql);
while ($row=hesk_dbFetchAssoc($result))
{
echo "
<option value=\"$row[name]\">$row[name]</option>
";
}

?>
</select></td>
</tr>
[/php]

Hope you guys can help me out as im pulling my hair out now.

Hi DirtySnipe,

Welcome to TSDN!

I had to do something similar recently and the way I decided to do it was to add a colum to the data source - isDefault as a tinyInt. then select this out in the SQL and during the processing of the data you can check for the value of this field and if it's set to 1 you can set selected="selected" in the processing code.

Here's an example from my database, this selects out countries from an ISO list and Sets United Kingdom as the default.

[php]
// get the data
$lcSelectStr =
"SELECT
a.ID, a.countryName as description, a.isDefault
FROM countrycode a
ORDER BY a.countryName ASC";

$laResults = $loDB->queryGetData($lcSelectStr); // my data object

// build the drop down
echo "<select name=" . "'" . "list" . $lnGetType . "'" . "id=" . "'" . "list" . $lnGetType . "'" . ">";
foreach($laResults as $lcDataLine)
{
echo "<option value=" . $lcDataLine['ID'] . " ";
if($lcDataLine['isDefault'])
{
echo "selected='selected'";
}
echo ">" . $lcDataLine['description'] ."</option>";
}
echo "</select>";

[/php]
I hope that helps.

Cheers
nathj

Oct 1 '07 #2

How to create a dynamic drop down box

Similar topics