dave2008

Hi, I am using php4 to upload a Tab delimited text file into a mysql database. Each row of data is placed into an array and then appended the database. What I need to do is add another column/field into the array. e.g I have my array (field1, field2, field3, field4) What I need to do id insert a new field between field2 and field3 The code I am currently using is shown below: if($action == "insert") { $fcontents = file("paypal.txt"); # expects the csv file to be in the same dir as this script for($i=0; $i<sizeof($fcontents); $i++) { $line = trim($fcontents[$i]); $line=str_replace(",", "", $line); $arr = explode("\t", $arr); $sql = "insert into mydb values ('". implode("','", $arr) ."')"; mysql_query($sql); echo $sql ."<br>\n"; if(mysql_error()) { echo mysql_error() ."unable to load $fcontents<br>\n"; } if(!mysql_error()) { echo "<br>Database updated"; } } Any help on this would be great Thanks Dave