Apparently an error in syntax

[beary]

Could someone please tell me what's wrong with the code below. It worked fine the first time, then I cleared the table (results) and tried it again, but got the message "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1".

Problem is I can't see any " near line. And it worked fine the first time. What am I missing?

Thankyou.

<?php
 
include("config.php");
include("opendb.php");
 
  $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]

Looks fine to me. To make sure I made this little test to see the results.[php]<?php
$arr = array("a", "b", "c");
$sql = "insert into results values ('','".
implode("','", $arr) ."')";
echo "1. $sql<br />";
$sql = "insert into results values ('','".
implode(',', $arr) ."')";
echo "2. $sql<br />";
$arr = array("a'", "b", "c");
$sql = "insert into results values ('','".
implode("','", $arr) ."')";
echo "3. $sql<br />";
?>[/php]
and the results were:[php]1. insert into results values ('','a','b','c')
2. insert into results values ('','a,b,c')
3. insert into results values ('','a'','b','c')

[/php]
Now 1 and 2 are fine, but inserting a quote in the array produces result 3 and makes the sql statement invalid. Echo your array content and see if that is the case here.

Ronald :cool: