Page 1 of 1

Database of 100 countries

Posted: Fri Apr 13, 2012 9:11 pm
by jamhussain
Aslam o alaikum,
Please guide me.
I have sheet with these columns

country country code inflows(Million) Year

Countries are 100
Each country has its code.
with respect to country there is inflows in million
Year :from 2001 to 2010
How can I make the database and table in Mysql. I m using php
so that I may select the country and year in the HTML Form then Post the values of Inflows(million) and then I may update Inflows

Re: Database of 100 countries

Posted: Sat Apr 14, 2012 10:04 am
by Christopher
First you need to define the database schema that contains the fields above and any others you want. Then import the data into the database. You can use tab-delimited or generate INSERT statements in you spreadsheet.

Once that it does you will need a page to browse and search for records to edit and a page to edit a record. Search for "CRUD" for more information on that.