Choosing 'selected' in drop down based in field value...
Posted: Sat Jul 18, 2009 6:42 pm
So I found this code below to populate a drop-down menu based on the categories found in a group of records. I'd like to use the same code on the edit page so that I can have the current field value for, in this case, categories auto-populate. Any ideas on how to accomplish this?
<?php
// Populate the Category Drop down
// Connect to the database
$dbc = mysql_connect("blahblah", "blahblah", "blahblah") or die("No connect");
mysql_select_db("blahblah",$dbc);
// Grab the categories
$query="SELECT DISTINCT id_category, name FROM Questions, Categories WHERE Questions.id_cardset = '" . $_GET['qid'] . "' AND Questions.id_category = Categories.id ORDER by name";
$result = mysql_query ($query, $dbc);
echo "<select name=category value=''>Category</option>";
echo "<option value='' selected>Select Category</option>";
echo "<option value=''></option>";
while($nt=mysql_fetch_array($result)){
echo "<option value=$nt[id_category]>$nt[name]</option>";
}
echo "</select>";
mysql_close($dbc);
?>
<?php
// Populate the Category Drop down
// Connect to the database
$dbc = mysql_connect("blahblah", "blahblah", "blahblah") or die("No connect");
mysql_select_db("blahblah",$dbc);
// Grab the categories
$query="SELECT DISTINCT id_category, name FROM Questions, Categories WHERE Questions.id_cardset = '" . $_GET['qid'] . "' AND Questions.id_category = Categories.id ORDER by name";
$result = mysql_query ($query, $dbc);
echo "<select name=category value=''>Category</option>";
echo "<option value='' selected>Select Category</option>";
echo "<option value=''></option>";
while($nt=mysql_fetch_array($result)){
echo "<option value=$nt[id_category]>$nt[name]</option>";
}
echo "</select>";
mysql_close($dbc);
?>