datto510

Hi, I have a form using post function Job No: <input type="text" name="jobno"><br and the next php file uses this code $objWriter->save("'jobno'.xlsx"); but its ignoring the variable thats being input

oh sorry i meant that here is an example of the sort of data / info that need to import. (tab separated) "ccorder" "cccode" "ccname" "ccgl" "ccgroup" "ccsecret" 1 1000 preliminaries 1.1 prelims 1 2 2000 site survey 1.1 prelims 1 3 3000 drafting 1.1 prelims 1 20 20000 excavation 1.1 slab stage 1 50 50000 roofing 1.1 enclosed 1

I am trying to import some data into a sql database. I am using the following sql to make the table eg the following script will make a new table. CREATE TABLE IF NOT EXISTS `est_costcenters` ( `est_ccorder` int(11) NOT NULL auto_increment, `est_cccode` varchar(100) NOT NULL default '', `est_ccname` varchar(100) default '', `est_ccgl` varchar(100) default '', `est_ccgroup` varchar(100) default '', `est_ccsecret` varchar(100) default '', PRIMARY KEY (`est_ccorder`) ) TYPE=MyISAM; but not sure how to fill it with required info. (of which there is a a lot) "ccorder" "cccode" "ccname" "ccgl" "ccgroup" "ccsecret" 1 1000 preliminaries 1.1 prelims 1 2 2000 site survey 1.1 prelims 1 3 3000 drafting 1.1 prelims 1 20 20000 excavation 1.1 slab stage 1 50 50000 roofing 1.1 enclosed 1