Espace en trop PHP

$value=str_replace(' ','',$value);
$value=addslashes($value);
$statement .= "'$value',";

Du genre SELECT #champs# FROM table_tampon INNER JOIN table_reference ON (table_tampon.NOM = table_reference.NOM AND table_tampon.PRENOM = table_reference.PRENOM AND table_tampon.DATENAISSANCE = table_reference.DATENAISSANCE

nom  

			foreach($values as $value)
			{
				echo "La valeur qui va être analysée est : " . $value . ".<br>";
				$derCarac = substr($value, -1);
				echo "Le dernier caratere de la valeur est : " . $derCarac . ".<br>";
				if(substr($value, -1) == "&#32;")
				{
					echo "Le dernier caractere est bien un espace. <br>";
					$value = substr($chaine,0,strlen($chaine)-1);
					$value=mysql_real_escape_string($value);
					$value = trim($value);
					echo "Voici la nouvelle valeur : <u>" . $value . "</u><br><br>";
					$statement .= "TRIM('$value'),";
				}
				else
				{
					echo "Le dernier caractere n'est pas un espace.<br>";
					$value=mysql_real_escape_string($value);
					$value = trim($value);
					echo "Voici la valeur finale : <u>" . $value . "</u><br><br>";
					$statement .= "TRIM('$value'),";
				}
			}

ID DES PARENTS;NOM;PRENOM;DATE DE NAISSANCE\n
56;mamie;papy;01/02/1980\n
120;tata   ;tonton;08/10/1958\n
79;mémé;pépé ;06/07/1985\n

include '../bdd/bdd.php';
$file = "/tmp/child_file.csv";
$content = file_get_contents($file,'r');
$lignes = split("\n", $content);
$handle = fopen($file, "r");

while (($data = fgetcsv($handle, 0, ";")) !== FALSE) 
{
        $last_line++;
}
unset($lignes[0]);
unset($lignes[$last_line]);
foreach($lignes as $ligne)
{
	$values = explode(";",$ligne);
	$statement = "INSERT INTO tabletampon (#CHAMPS#) VALUES(";
	foreach($values as $value)
	{
		$value=mysql_real_escape_string($value);
		$value = trim($value);
		$statement .= "TRIM('$value'),";
	}
	$statement = substr($statement,0,strlen($statement)-1);
	$statement.= ");";
	mysql_query($statement) or die('<br>Erreur base de donnée !<br>'.$statement.'<br>'.mysql_error());
	}
	fclose($handle);

$statementsOne = "SELECT #CHAMPS# FROM tabletampon WHERE (
tabletampon.NOM NOT IN (SELECT nom FROM table_ref)
AND 
tabletampon.PRENOM NOT IN (SELECT prenom FROM table_ref)
AND 
tabletampon.DATENAISSANCE NOT IN (SELECT date_anniv) FROM table_ref)
);";
$requOne = mysql_query($statementOne) or die(mysql_error());	
	
$date = date("d/m/Y");
while($data = mysql_fetch_array($requAdHorusOne))
{
	$statemenTwo = "INSERT INTO table_ref (#CHAMPS#) 
        VALUES (
        (SELECT ID FROM tableRefParent WHERE nom = '" . $data[NOM] . "' AND prenom = '" . $data[PRENOM] . "' AND         date_naissance = '" . $data[DATENAISSANCE] . "'), 
        '" . addslashes(trim($data[NOM])) . "', 
        '" . addslashes(trim($data[PRENOM])) . "', 
        '" . addslashes(trim($data[DATENAISSANCE])) . "', 
        '" . $date . "');";
        mysql_query($statementAdHorusTwo) or die('mysql_error());	
}

include '../bdd/bdd.php';
$file = "/tmp/child_file.csv";

$handle = fopen($file, "r");

while (($data = fgetcsv($handle, 0, ";")) !== FALSE) 
{
	$statement = "INSERT INTO tabletampon (#CHAMPS#) VALUES(";
	foreach($data as $value)
	{
		$value = trim($value);
		$value=mysql_real_escape_string($value); // l'ordre trim / mysql... est plus logique comme ça
		$statement .= "'$value',";
	}
	$statement = substr($statement,0,strlen($statement)-1);
	$statement.= ");";
	mysql_query($statement) or die('<br>Erreur base de donnée !<br>'.$statement.'<br>'.mysql_error());
	}
	fclose($handle);

� 

ﾠ

if(substr($value, -8) == "�" ||  substr($value, -8) == "ﾠ" ||  substr($value, -1) == " ")
	{
	echo "Le dernier caractere est bien bizarre. <br>";
	$value = substr($chaine,0,strlen($chaine)-1);
	$value = trim($value);
	$value=mysql_real_escape_string($value);
	echo "Voici la nouvelle valeur : <u>" . $value . "</u><br><br>";
	$statement .= "'$value',";
}