I have a web site that is similar to twitter. It's a microblog that has group messaging functions so that users can send messages to a group of people at one time.
I have a huge list of schools that I need to import from csv files into a table on the server so that users can send messages to everyone in their school.
The way I need to categorize the school listing is as follows:
My current group setting only allows the following:
So as you see I need two more levels of categories for the schools.
The other option for this is to make a smart search tool that will allow the user to just type in the name of the school that they are looking for and have all of the matching schools show up for them to choose from.
Either way, I will still need the table where the schools are added to be modified to hold the school details, address, city, state, postal code, etc. This information should be shown to the user.
This project can be done with my API or through some modification of the of the script, but I prefer using the API.