Dropdown box help

webweever

The code below will create a dropdown box with all the stores listed, how can I have the dropdown set to a store value that is set in the DB?

For instance, a user submits and item to my DB that is from Kroger. When the user wants to edit that Item I need the dropdown box to be set to Kroger but have the other store values in the list.

<?php
		$sql="SELECT * FROM store";
		$result=mysql_query($sql);
		$options="";

            while ($row=mysql_fetch_array($result)) {
	$storename = $row["store_name"];
	//$cat_id=$row["cat_id"];
	$options.="<OPTION VALUE=\"$storename\">" .$storename."</option>";
	}
	while (isset($_POST['store_name']) && is_array($_POST['store_name'])) {
	$items = implode(", ", $_POST['store_name']);
}
?>
<SELECT NAME=store[]>Category<?php echo $options?></SELECT>

Derokorian

while ($row=mysql_fetch_array($result)) {
   $storename = $row["store_name"];
   //$cat_id=$row["cat_id"];
   $options.="<OPTION VALUE=\"$storename\"";
   $options.= ($storename == $selectedstorename) ? ' selected' : '';
   $options.=">" .$storename."</option>";
}

// which is the same as
while ($row=mysql_fetch_array($result)) {
   $storename = $row["store_name"];
   //$cat_id=$row["cat_id"];
   $options.="<OPTION VALUE=\"$storename\"";
   if( $storename == $selectedstorename ) $options .= ' selected';
   $options.=">" .$storename."</option>";
}

Where $selectedstorename is the name of the store that should be showing by default, however you do that

webweever

Derokorian;10980344 wrote:
Where $selectedstorename is the name of the store that should be showing by default, however you do that

Not sure what you mean by this.

Derokorian

I mean that variable would need to be the store that you want highlighted. I don't know how you retrieve the information showing what the default values should be for editing, but that should be a variable where you put the default store, it then checks if the current store being listed matches the one that should be highlighted, if it does it makes it selected if not it makes it a regular option field.