从脚本生成查询时出现Mysql语法错误

Question

I have a script that generates a query, the query is then executed using mysql_query()

It shows an error I can't work out...If I echo the sql statement and execute it on phpmyadmin it works perfectly.

function magikarp($table, $arr)
{
$data=array();
$campos="";
$val="";

for($c=0;$c<count($arr);++$c)
{
    $var=make_safe(current($arr));
    if($var!="")
    {
        $campos=$campos.key($arr).",";
        $val=$val."".current($arr).",";
        $data[key($arr)]=$var;
    }
    next($arr);
}

$campos[ strlen($campos)-1]=''; //THIS IS FOR THE EXTRA COMA AT THE END
$val[ strlen($val)-1]='';

    $sql = "INSERT INTO $table ($campos) VALUES ($val)"; 

//trim($sql);
echo $sql;

$result = mysql_query($sql);
if (!$result) {
    die('Invalid query: ' . mysql_error());
}
return $data;

}


IT ECHO
INSERT INTO clientes (cedula,nombre,apellido) VALUES ('123','5454','51515')

Answer 1

The error was some hidden characters in my text editor.