[SOLVED] Handling CSV file

[jeeves245]

Hi guys,

 

can anyone tell me why this script isn't working? It is inserting the rows in the database, but they do not have any data in them.

 

Cheers.

 

<?php

$con = mysql_connect("localhost","root","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("database", $con);

$file_handle = fopen("deliveries.csv", "rb");

while (!feof($file_handle) ) {

$line_of_text = fgets($file_handle);
$parts = explode(',', $line_of_text);

$sql="INSERT INTO customer (customerName, address1, address2, address3)
VALUES
('$parts[2]','$parts[6]','$parts[7]','$parts[8]')";

}

fclose($file_handle);

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
   
?>

 

[abazoskib]

after declaring the sql statement, you must use

mysql_query($sql);

[jeeves245]

Ah, that did it. Thanks