Aidez moi à retrouver mon erreur

Fermé
amamasters Messages postés 1 Date d'inscription mercredi 4 novembre 2009 Statut Membre Dernière intervention 4 novembre 2009 - 4 nov. 2009 à 12:13
Bonjour, j'ai un script php ki m'envoie une erreur que je n'arrive pas à trouver:

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 '"INSERT INTO IPTC VALUES('', '"004483_24"', '""', '""', '"CUL"', '""', '""', '"S' at line 1


voici le script. en fait il enregistre les données iptc d'une photo dans la table iptc:


<?php
include('config/connexion_bdd.php');
$code = array("005","007","010","015","020","022","025","030","035","040","045","047","050","055","060","065","070",
"075","080","085","090","095","100","101","103","105","110","115","116","120","122");

$dir = opendir("bankimages/tmp");
//$i = 0;
while($file = readdir($dir))
{
//echo "$file";
GetImagesize('bankimages/tmp/'.$file, $info);
$iptc = iptcparse($info["APP13"]);
$i = 0;
$donnee = array();
$req = "\"INSERT INTO IPTC VALUES(''";
foreach($code as $val)
{
$c_code = "2#".$val;
$ttab = sizeof($iptc[$c_code]);
if (isset($iptc[$c_code][0]))
$donnee[$i] = $iptc[$c_code][0];
else
$donnee[$i] = "";
$j = 1;
while ($j < $ttab)
{
$donnee[$i] .= ".".$iptc[$c_code][$j];
$j++;
}
$donnee[$i] = str_replace(",", ";", $donnee[$i]);
$req .= ", "."'".'".'.addslashes($donnee[$i]).'."'."'";
$i++;
}
$req .= ")\";";
//echo "$req <br/><br>";
mysql_query($req) or die(mysql_error());
//if ($test)
//echo"bon";
//else echo"mauvais ";
}
closedir($dir);
?>