i have a sql file with all the required queies... how can i with php make the connection to mysql n create tables n insert the values
DROP TABLE IF EXISTS ip2nation;
CREATE TABLE ip2nation (
ip int(11) unsigned NOT NULL default '0',
country char(2) NOT NULL default '',
KEY ip (ip)
);
DROP TABLE IF EXISTS ip2nationCountries;
CREATE TABLE ip2nationCountries (
code varchar(4) NOT NULL default '',
country varchar(255) NOT NULL default '',
lat float NOT NULL default '0',
lon float NOT NULL default '0',
PRIMARY KEY (code),
KEY code (code)
);
INSERT INTO ip2nation (ip, country) VALUES(0, 'us');
INSERT INTO ip2nation (ip, country) VALUES(687865856, 'za');
INSERT INTO ip2nation (ip, country) VALUES(699400192, 'eg');
INSERT INTO ip2nation (ip, country) VALUES(699465728, 'za');
INSERT INTO ip2nation (ip, country) VALUES(699531264, 'eg');
INSERT INTO ip2nation (ip, country) VALUES(700448768, 'za');
INSERT INTO ip2nation (ip, country) VALUES(700710912, 'eg');