update all fields except 1st 5

[beary]

I have some code to import data from a csv file into a mysql table like below. It works perfectly. What I need to do, though, is to get it to import all of the 154 fields except the first 5. Actually, the 1st field (before the comma) is a blank field which is the auto-incrementing id field. Then it's the next 4 that are the problem. In the mysql table, these fields must not have data entered by the import, but all other fields must have the data imported. This is probably very easy, but I am new at this. Is anyone able to tell me what I need to do? Thankyou.

$fcontents = file ('mysqldata.csv'); 
 
  for($i=0; $i<sizeof($fcontents); $i++) { 
      $line = trim($fcontents[$i]); 
      $arr = explode(',', $line); 
 
      $sql = "insert into results values ('','".implode("','",$arr)."')"; 
      mysql_query($sql);
 
      if(mysql_error()) {
         echo mysql_error() ."<br>\n";
      } 
}
 

[ronverdonk]

If your data is in the correct field order, e.g. starting with field 5, you should use the columns specification of the MySQL INSERT statement. Hereby you specify the column names and in the order in which the values() should be inserted. Such as:

"insert into results (col5, col6, col7, col8,..... coln) 
              values ('".implode('",$arr)."')";

Ronald :cool:

[beary]

Ok. I understand what you mean and can easily change the statement. However, the csv file which is being imploded still has those 1st 4 fields which I don't want inserted. Won't they be inserted even if I specify the column names? (Sorry if my questions seems stupid; I'm just trying to get my head around it.)

[ronverdonk]

Get the first 4 array entries out by using PHP array functions, i.e. the array_shift() function. See http://nl3.php.net/manual/en/function.array-shift.php

Ronald :cool:

[beary]

Oh good. Excellent. Thanks Ronald!