Posted by NC on 10/10/32 11:45

Sonoman wrote:
>
> I have an approach problem and I would like to hear how would others handle
> this. I have a NAICS database which consists of all the business categories
> in the US, the respective code number and a text description. The number is
> a 6 digit number where the first two are the main categories, the third is a
> sub category and so on. I have this already broken down on the database.

Bad idea. You should have retained the shorter codes as well. This
way, you could allow the user to browse the hierarchy of sectors,
subsectors, and industries.

> There are way too many records to have a user browse through the whole
> thing, so what I though was to have a series 5 of drop down menus where the
> first has the main two digit categories and the others are blank. As soon as
> you selects a category from the first drop down the corresponding sub
> categories will show on the second drop down and so on until the user builds
> the correct NAICS number based on the selections.

This is best done with JavaScript. A more "pure-PHP" alternative is to
create something like this:

http://www.ncbase.com/NAICS/1.php

Cheers,
NC

[Back to original message]