The option goes into the database, and I want to pull out the data (using PHP) and have the option that they chose as the default value. How can I do this?

I have no idea. But you might try asking this in the PHP forum. You might get some answers there.

Assume, that your data for creating select box are inarray $options and value from database is in $selectedValue variable.

PHP Code:

$selectedValue= ... // this is value from database;

echo "<select name='aaa'>";
for ($i=0,$count=count($options);$i<$count;++$i)
{
   echo "<option value='".$options[$i]['value']"'";
   if ($options[$i]['value']==$selectedValue)
     echo " selected='selected'>";
   else
     echo ">";
   echo $options[$i]['description']."</option>";
}
echo "</select>"; 


in simple terms, add selected='selected' into your option field

e.g.

<option value='xxx' selected='selected'> simple huh?

Originally Posted by pitbull82

Assume, that your data for creating select box are inarray $options and value from database is in $selectedValue variable.

PHP Code:

$selectedValue= ... // this is value from database;

echo "<select name='aaa'>";
for ($i=0,$count=count($options);$i<$count;++$i)
{
   echo "<option value='".$options[$i]['value']"'";
   if ($options[$i]['value']==$selectedValue)
     echo " selected='selected'>";
   else
     echo ">";
   echo $options[$i]['description']."</option>";
}
echo "</select>"; 


I've just tried this. This is the code I have used...

PHP Code:

$selectedValue= "Tom"; // this is value from database;

$options = array();
$options[0] = "Tom";
$options[1] = "Charlie";

echo "<select name='test'>";
for ($i=0,$count=count($options);$i<$count;++$i)
{
   echo "<option value='".$options[$i]['value']"'";
   if ($options[$i]['value']==$selectedValue)
     echo " selected='selected'>";
   else
     echo ">";
   echo $options[$i]['description']."</option>";
}
echo "</select>"; 


I get the following error:

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /mounted-storage/home17a/sub002/sc19014-UDPB/alldrumtabs.com/warnings.php on line 12

Line 12 being:

PHP Code:

echo "<option value='".$options[$i]['value']"'"; 


Here's the exact code:

PHP Code:

<?php
$selectedValue= "Charlie"; // this is value from database;

$options = array();
$options[0]['value'] = "Tom";
$options[0]['description'] = "Tom";
$options[1]['value'] = "Charlie";
$options[1]['description'] = "Charlie";

echo "<select name='test'>";
for ($i=0,$count=count($options);$i<$count;++$i)
{
   echo "<option value='".$options[$i]['value']."'";
   if ($options[$i]['value']==$selectedValue)
     echo " selected='selected'>";
   else
     echo ">";
   echo $options[$i]['description']."</option>";
}
echo "</select>";
?>