dropdown menu question

[marccesar]

i have a drop down menu which is being built from values in my database..how do i specify which value to select when the page loads? thanks!

[poirot]

You can use Javascript and select it when the page loads....
Or figure out which value you want to replace to select and use str_replace, preg_replace and so on.

Like:

[code]$pattern = 'value="' . $should_be_selected . '"';
str_replace($pattern, $pattern . ' selected="selected"', $subject);[/code]

[Fyorl]

I think I've already answered this in another thread, but I can't remember if you posted it or not. Either way:[code]$sql = mysql_query("SELECT *
FROM `table`
WHERE `something`='1'"); // Do the database query
echo "<select name=\"members\">"; // Start off the drop-down menu
while($row = mysql_fetch_array($sql))
{
echo "<option";
if($row['name'] == 'fyorl')
{
echo " selected>"; // This makes the option selected
}
else
{
echo ">";
}
echo "$row[name]</option>";
}
echo "</select>"; // End the menu[/code]

[marccesar]

thanks for your help, worked perfectly!