First of all, I am using Dreamweaver CS4. ( If that matters ).
I am using a list-menu that is populated using a large table of SIC Industry Codes, ( about 15,000 ).
My query is:
SELECT DISTINCT `sic_code` , `sic_industry`
FROM `smf_sictable`
Both sic_code & sic_industry are indexed.
When I test this online, the dropdown list box takes about 10-15 seconds to fully load and while it is loading, you can see all of the data loading into the dropdown list box.
I have tried to list the values directly into my page like this:
<select name="Industry:" class="autoconvert">
<option value="00000" selected="selected">Enter Industry Name Here...</option>
<option value="11100">Wheat Farm</option>
<option value="11200">Rice Importer/computer Consulting</option>
<option value="11500">Corn Farm Soybean Farm Real Property Lessor</option>
<option value="11500">Corn Farm Soybean Farm</option>
<option value="11600">Soybean Farm</option>
<option value="11904">Cash Grains Farm</option>
</select>
The autoconvert class was purchased as a dreamweaver extension. This extension allows you to convert a Combo Box into an Autocomplete field.
This seems to work somewhat quicker than taking a trip to the database. However, I can't help but to think that there must be some way that I can pre-load these values.
Is there a faster, more efficient way of populating a list menu using php, or some other language ?
I will need to use this list-menu (combobox) more than once, does anyone know how I go about making this into a function ?
Thank you,
Terry Mullins