List Box Problem

[Shit4Brains]

I got a problem with a list box. My list box is huge has. 100+ items in it. When the page is displayed a value is gotten out of the database and this value corresponds to a item in the list box which i want to display. But how do i do it? coz you have to put 'selected' in the option.

[laserlight]

One way would simply to add an extra selected option at the top.
The downside is that you would have 2 identical options.

Another way would be to dynamically generate the drop down menu, and so make the relevant option selected as is appropriate.
The downside is that you spend extra time in the processing.

[Shit4Brains]

cant do it like that. the values in the list box arnt in running order which makes things really difficult.

    [code=php]<tr>
      <td width='38%'>$title_prefix Job Sector: $title_suffix</td>
      <td width='62%'><select name='JOB_SECTOR' onchange='ChangeDetail(this.form)'>

<option value='0'>--(Select a Job Sector)--</option>
<option value='2'>Accountancy</option><option value='3'>Admin &amp; Secretarial</option><option value='5'>Banking</option><option value='146'>Building &amp; Construction</option><option value='66'>Customer Service</option><option value='68'>Education</option><option value='12'>Engineering</option><option value='117'>Financial Services</option><option value='16'>General Insurance</option><option value='36'>Health &amp; Medicine</option><option value='06'>Hospitality &amp; Catering</option><option value='24'>HR &amp; Training</option><option value='52'>IT</option><option value='101'>Legal</option><option value='168'>Manufacturing</option><option value='18'>Marketing &amp; PR</option><option value='362'>Pharmaceuticals</option><option value='338'>Recruitment Consultancy</option><option value='90'>Retail</option><option value='30'>Sales</option><option value='89'>Scientific</option><option value='34'>Social Care</option><option value='11'>Transport &amp; Logistics</option></select>
</select></td>[/code]

maybe looking at my code mite help

all i need it to do is: for example: find value 2 ( accountancy ) and display it first.

[laserlight]

cant do it like that. the values in the list box arnt in running order which makes things really difficult.

The order doesnt matter.

[Bah__Name]

I'm not at my home PC so I don't have my code on me but you can put it in a loop, and for 'selected' you can do something like

print "<option value='24' selected =".GetSelected(aThis[$i])."> HR & Training</option>";

Something along these lines, my syntaz might be off. Search the site for list boxes, and selected etc you may turn up the answer. I do that a lot.

Bah.

[Bah__Name]

PS - your example code has two </select> tags - don't know if you know this..

[ericbb]

I did it like this:

$query = "SELECT some_id, some_name 
	FROM sometable 
	WHERE some_id = '$some_id'
	ORDER BY some_name";
$result = mysql_query($query) or die(mysql_error());


while ($sectors = mysql_fetch_array($result))
{ 
	if ($your_page_value == $sectors[0])
	{
		$select = ' selected';
	}
	else
	{
		$select = '';
	}

            print("<OPTION VALUE=\"$sectors0]\"$select>$sectors[1]\n");
}