Re: Select list with PHP

> while ($row = mysql_fetch_array($sql_result)) { > echo"<tr><td>"; > echo $row["paint"]; > echo"</td><td>"; > echo $row["bucket"]; > echo"</td><td>"; > echo"<form action=\"http://www.\" > method=\"POST\">"; > $Color = $row["Color"]; > if ($Color == $Color) { Here is one problem: You can't use $Color for the current color you are printing *AND* the color they previously selected. $Color == $Color will *always* turn out to be TRUE. It's a "truism", like asking if ("Blue" == "Blue") You need a separate variable name for the selected color, like, $SelectedColor, or you could use $Col for the $row["Color"], but you can't use $Color for both the selected color and the current possible option. > $option .= "<OPTION value=\"$Color\" selected>$Color</OPTION>"; > } else { > $option .= "<OPTION value=\"$Color\">$Color</OPTION>"; > } > echo"<select name=\"Colors\">"; > echo "$option"; > echo"</select>"; > > as you can see I end up with a select menu with this "green, blue, red" > as the only option. > > is there a way I can tell php3 to break it down at "," so I can actually > have a drop down menu Something like this inside your loop might be what you want: $Colors = $row["Color"]; $options = explode(",", $Colors); while (list(,$Color) = each($options)){ $option .= "<OPTION>$Color</OPTION>\n"; } I'm not real sure that you should have Red, Green, Blue in your database in the first place though... It's usually a better idea to store this as a "relation": Colors: ColorID Color --------------- 1 Red 2 Green 3 Yellow 4 Blue Buckets: BucketID Paint Bucket Weight ---------------------- 1 Good Good 100kg 2 Okay Good 120kg BucketColors -------------- BucketID ColorID 1 1 1 2 1 4 2 1 2 3 This last table says, that bucket # 1 is "related to" Color 1 (Red), Color 2 (Green) and Color 4 (Blue) Bucket #2, on the other hand, is "related to" Color 1 (Red) and Color 3 (Yellow) But, if all you are doing is saying that the only choices for a Bucket ever are Red/Green/Blue, ignore all that... :-) -- Visit the Zend Store at http://www.zend.com/store/ Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm