Edit Form & Drop Down box issues

[iceblox]

Hi Guys,

 

Im still a PHP newbie and i have a bit of script which allows me to edit stuff in my database but im trying to get it to work with a drop down box. So that when i use the page it will automatically select that option in the drop down. If that makes sense?

 

I have this but it is selecting every option...

 

here is the code...

 

        $manufacturer="<option>Select a Manufacturer</option>";
$result = $db->sql_query("SELECT * FROM manf ORDER BY manfname ASC");
while($row = $db->sql_fetchrow($result))
{
	$selected="";
	if($row["manfid"]==$manfid)
		$selected = " selected=\"selected\"";
	$manufacturer.="<option$selected value=\"".$row["manfname"]."\">".$row["manfname"]."</option>";
}

 

 

Any ideas?

[AV1611]

they are selected because you are telling them to be selected.  Do you want them selected?

 

(I think?)

[iceblox]

Sorry i probably didnt explain it well. The edit function is to edit a mobile phone review, the drop down box has the manufacturers in and the only one i want selected is the manufacturer that relates to the mobile being edited. Does that sound clearer?

 

Cheers

[AV1611]

So, you want a drop down that lists all possible manufactures, but highlights only the one applicable to what the user has previously select?

[iceblox]

Yeah

[AV1611]

Hi Guys,

 

Im still a PHP newbie and i have a bit of script which allows me to edit stuff in my database but im trying to get it to work with a drop down box. So that when i use the page it will automatically select that option in the drop down. If that makes sense?

 

I have this but it is selecting every option...

 

here is the code...

 

        $manufacturer="<option>Select a Manufacturer</option>";
$result = $db->sql_query("SELECT * FROM manf ORDER BY manfname ASC");
while($row = $db->sql_fetchrow($result))
{
	$selected="";
	if($row["manfid"]==$manfid)
		if($manfid==$_POST['MANFID']) //<---assumes selected on previous screen
		{$selected = " selected=\"selected\"";}
		else{$selected = "";}
	$manufacturer.="<option$selected value=\"".$row["manfname"]."\">".$row["manfname"]."</option>";
}

 

 

Any ideas?

[iceblox]

;O)

[rantsh]

Here comes CSS to the rescue

 

adapt the following to your script

 

<select>
<option>Sony Ericcson</option>
<option style="background-color:#FFFF00">Motorola</option>
<option>Nokia</option>
</select>

 

Tested it on Opera 9+, FF2.0, IE7 and IE6, I'm guessing this is what you want...

[iceblox]

I Think ive got it! Cheers Guys!