views:

123

answers:

4

Not sure if this is the proper place to post this question, but I've seen questions regarding ISBN databases, so I thought it would be appropriate.

In my website, I intend allow my users to choose between all the US college/universities (community or 4 year institutes). I would then store their selection in a database.

At first I thought about allowing them to input the name themselves, but saw some issues with that. I tried to look for a database of some sort, but all I found were search engines to find a specific university.

I was hoping to find a database can I export to my own database (SQL Server) and have users search my own database.

Has anyone come across this issue and found a reasonable solution?

A: 

Create a web application that interfaces with your database. I guess? Make your question more clear please.

Woot4Moo
+1  A: 

googling for 'list of us universities' gives me a lot of hits.
you could have a textbox which allows them to enter the name themselves but offers autocomplete functionality which aids them in inputing a string which is an exact match to one in your database (sort of like how facebook autocompletes the friend search on the top right)
if the user ignores this and specifies an unknown string, you could either add this new string to your database or refuse, saying that they should ask the admin to add it for them and then try again

adi92
A: 

You can combine these two by having a search box with auto complete, if the input query does not match, indicate if they want to add this into database. You can create a table in database to hold all these contributions and they won't get added to the list before you or someone approve it.

Jay Zeng
+2  A: 

A few different links that may help:

AllAboutUni.com is a one stop portal which will help you select your future university. We want you to find a university or college where you will be happy, and where there is a good blend of academic support, extracurricular activities, safety and friendliness.

JB King