Creating a database help --im a n00b

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
zulu99xray
Forum Newbie
Posts: 1
Joined: Fri Apr 06, 2012 6:06 pm

Creating a database help --im a n00b

Post by zulu99xray »

Hello, i pretty much want to create a website dedicated to college reviews, but that is pretty irrelevant as to why i am on here.

Right now i have EVERY single college in the US listed in a txt file. I can also seperate them by state which is what i will do later. But for now i want to figure out how to put them into MYSQL database. I want to do this so that each college will have its own review page. Obviously i cant just go out and create 3,000 pages of html, it has to be done this way. If anyone wants to work with me that would be great, i have yahoo messenger: 99zuluxray. But if you just want to give advise on here then maybe you can tell me how i would go about getting the colleges into a database. I guess actually now that i think of it one entire database that has states then under each state is listed the colleges. I really have no clear way to do this. i am not a developer what-so-ever, this is for my recreation.

THANKS!
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Creating a database help --im a n00b

Post by Christopher »

What does the text file look like? What format is it in? Can you show us one small section?
(#10850)
Post Reply