change choice to whatever is selected.

[newb]

[code]
<?php
  $query = $config->query("SELECT * FROM table_modules");
            echo "<select name='conf_default_mod'>";
while ($row = mysql_fetch_array($query)) {
echo "\n<option value='$row[id]'>$row[name]</option>\n";
}
            echo "
          </select>   
?>
[/code]

how do i change the code so that it echo's whatever option is selected in the database. like selected="selected" . any one know how?

[Daniel0]

Inside the loop: [code]$selected = $row['is_selected'] ? " selected='selected'" : null;
echo "\n<option value='$row['id']'{$selected}>$row['name']</option>\n";[/code]

[newb]

didnt work., i dont have a $row'is_selected' field in my table.

[Daniel0]

No, but use what corresponds to your database structure.

[newb]

ah i got it to work :D

[newb]

[code]
<?php
  $query = $config->query("SELECT * FROM table_modules");
            echo "<select name='conf_default_mod'>";
while ($row = mysql_fetch_array($query)) {
$option = "\n<option value='$row[id]'>$row[name]</option>\n";

$query2 = $config->query("SELECT * FROM table_settings WHERE id='11'");
$row2 = mysql_fetch_array($query2);
$def_mod = $row2['value'];

if(eregi("$def_mod",$option)) {
$option = str_replace($option,"\n<option value='$row[id]' selected='selected'>$row[name]</option>\n",$option);
} else { $option = "\n<option value='$row[id]'>$row[name]</option>\n"; }

echo $option;
}
            echo "
          </select>";
?>
[/code]
incase anyone wanted to know how it was done