Jump to content

Archived

This topic is now archived and is closed to further replies.

marccesar

dropdown menu question

Recommended Posts

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!

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.