database of 100 countries.

[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
so that I may select the country and year in the HTML Form then Post the values of Inflows(million)

[tomhath]

There are some good tutorials on using PHP and MySQL to build web pages. It would help you a lot to find an example and get it working, That will show you how to create tables, insert data, and pull the data back out into a web page. Then all you need to do is change the tables to hold your data, something like this (not tested):

create table Countries (
  countryId int NOT NULL AUTO_INCREMENT,
  country varchar(60),
  countryCode varchar(16),
  PRIMARY KEY (countryId )
);

create table Inflows (
  countryId int,
  dataYear int,
  inFlow int,
  PRIMARY KEY (countryId, dataYear)
);