[RESOLVED] mysql syntax error (cli)

[maddin]

i started writing a litte cli script that should simply perform one "insert" command. but everytime i execute this litte script i get a sql syntax error. when i execute my query via phpmyadmin i get no errors and everything is ok.

the script (shortend):

if(mysql_connect("xxx", "xxx", "xxx")) echo "Connect OK";   // OK
if(mysql_select_db("xxx")) echo "Select OK";     //OK

$query = "INSERT INTO xxx VALUES ('0', '$x1', '$x2', '$x3', '$x4');";

if(mysql_query($query))    // syntax error
	echo "OK";
else
	echo "failed ".mysql_error();

i'm using php5, mysql4.1, apache2 on win xp
phpmyadmin and a forum software work without any problems.

thanks in advance

[nemonoman]

You need to post the actual query as sent to the server. If your variables, for example, include apostrophes, the query will fail.

$x1="This isn't going to work";

mysql_query("INSERT INTO xxx VALUES ('$x1'))"; //fails

[maddin]

ok, here is the query string again and some comments

$query = "INSERT INTO uploads VALUES (0, '$filename', '$p_path', '$v_path', '$time');";

$filename: normal filename, only allowed characters
$p_path: the physical path, for example: C:\test
$V_path: virtual path on server, for example: /upload
$time: unix timestamp

the error message i get is:
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 '1122407156')' at line 1

update: problem resolved! 🙂

your hint made me think...
i added "addslashes()" to the vars in my query and now it works

thx for your help.
yeah...