function process($posted) { db_connect(); for ($i = 2; $i < 38; $i++) { $csarr = split(",", $posted[$i]); $sql = mysql_query("INSERT INTO bioc11 (LastName, FirstName, Email, Institution, password) values('$csarr[0]','$csarr[1]','$csarr[2]','$csarr[3]','w345t');"); echo $sql; } } ?> function db_connect() { //strictly speaking its silly that this is here, in principal we're getting rid of php soon so I dont care. // MySQL Server Connection Information $dbuser = 'biocomp'; $dbpass = 'Zahpqe0953'; global $link; $link = mysql_connect('localhost', $dbuser, $dbpass) or die("DB Access Error"); mysql_select_db('biocomp', $link) or die("Cannot connect to table"); } ?> $arr[0] = ""; $arr[1] = ""; $arr[2]="Aktipis,Athena,athena.aktipis@gmail.com,U Arizona"; $arr[3]="Angelini,Thomas,angelini@seas.harvard.edu,Harvard"; $arr[4]="ben-Avraham,Daniel,qd00@clarkson.edu,Clarkson"; $arr[5]="Blackstone,Neil,neilb@niu.edu,Northern Illinois"; $arr[6]="Costa,Jose,jose.costa@yale.edu,Yale"; $arr[7]="Couzin,Iain,icouzin@princeton.edu,Princeton"; $arr[8]="Durand,Pierre,Pierre.Durand@wits.ac.za,Witwatersrand South Africa"; $arr[9]="Extavour,Cassandra,extavour@oeb.harvard.edu,Harvard"; $arr[10]="Fernandez,Ariel,arifer@rice.edu,Rice"; $arr[11]="Fisher,Daniel,dsfisher@stanford.edu,Stanford"; $arr[12]="Gatenby,Robert,robert.gatenby@moffitt.org,Moffit Cancer Ctr"; $arr[13]="Gavrilets,Sergey,gavrila@tiem.utk.edu,NIMBioS U of Tennessee"; $arr[14]="Gore,Jeff,gore@mit.edu,MIT"; $arr[15]="Goyal,Sidhartha,goyal@kitp.ucsb.edu,KITP"; $arr[16]="Hidalgo,Cesar,cesifoti@gmail.com,MIT"; $arr[17]="Hogeweg,Pauline,p.hogeweg@bio.uu.nl,Utrecht"; $arr[19]="Julou,Thomas,thomasjulou@ens.fr,ENS Paris"; $arr[20]="Klapper,Isaac,klapper@math.montana.edu,Montana State"; $arr[21]="Levine ,Herbert,hlevine@ucsd.edu,UCSD"; $arr[22]="Lowengrub,John,lowengrb@math.uci.edu,UC Irvine"; $arr[23]="Mani,Madhav,madhav.mani@gmail.com,KITP"; $arr[24]="Maley,Carlo,cmaley@wistar.org,Wistar"; $arr[25]="Martin,Bill,W.Martin@uni-duesseldorf.de,Duesseldorf"; $arr[26]="Mehdiabadi,Natasha,mehdiabadi@si.edu,Smithsonian Institute"; $arr[27]="Merks ,Roeland,roeland.merks@sysbio.nl,NISB-Amsterdam"; $arr[28]="Michod,Rick,michod@u.arizona.edu,U Arizona"; $arr[29]="Miikkulainen,Risto,risto@cs.utexas.edu,U Texas"; $arr[30]="Nedelcu,Aurora,anedelcu@unb.ca,U New Brunswick"; $arr[31]="Nelson,David,nelson@physics.harvard.edu,Harvard"; $arr[32]="Redner,Sid,redner@bu.edu,BU"; $arr[33]="Ruiz-Trillo,Inaki,inaki.ruiz@icrea.es,ICREA Barcelona"; $arr[34]="Selinger,Jonathan,jselinge@kent.edu,Kent State"; $arr[35]="Shakhnovich,Eugene,eugene@belok.harvard.edu,Harvard"; $arr[36]="Sneppen,Kim,sneppen@nbi.dk,NBI Denmark"; $arr[37]="Tarnita,Corina,corina.tarnita@gmail.com,Harvard"; process($arr); ?>