show "You have an error in your SQL syntax near "

vivi6666666

when save database to mysql show err message

"You have an error in your SQL syntax near "
near '(filename,name,countery,inputdate,discr) VALUES('DFDF','DFDF','DFD','2002-10-28'' at line 2 "

i create a tabel use php to write

<?php
$link_ID = mysql_connect("localhost","root");
//connect myySQL
mysql_select_db("dynascan");
$sql_string = "
CREATE TABLE file (
fileid int(5) unsigned DEFAULT '0' NOT NULL auto_increment,
filename varchar(50) NOT NULL,
name varchar(50) NOT NULL,
countery varchar(20),
inputdate date NOT NULL,
discr tinyblob,
PRIMARY KEY (fileid)
)
";
mysql_query("$sql_string") or die (mysql_error());
?>

write to database mysql

$eintragquery = "INSERT INTO $userstable
(filename,name,writer,inputdate,comment)
VALUES('$filename','$name','$writer','$inputdate','$comment')";

when save to mysql shwon err message "
You have an error in your SQL syntax near '(filename,name,countery,inputdate,discr) VALUES('DFDF','DFDF','DFD','2002-10-28'' at line 2 "

Can you tel me what error ?

Phantazm

Without seeing all your code, it's somewhat difficult to say...

What I would do before anything else is to simply echo the mySQL query instead of executing it (for dubugging only of course)...

i.e...

  $query = "INSERT INTO $table (x,y,z)  VALUES ('$x','$y','$z')";
  echo $query;

This way, it will show you EXACTLY what is contained in the query.. maybe it'll help you some

sachinrase

boss
ur query has a variable undeclare
$userstable ??
so please exec query with variable
name as something

over here is

$userstable="file";
$eintragquery = "INSERT INTO $userstable
(filename,name,writer,inputdate,comment)
VALUES('$filename','$name','$writer','$inputdate',
'$comment')";

========================
One more thing put "\n" after each SQL syntax for debuging ur sql
e.g

$sql= " Insert into blash "
."\n (name, id )"
."\n VALUES "
."\n(foo, 1)";

vivi6666666

Originally posted by Phantazm
Without seeing all your code, it's somewhat difficult to say...

What I would do before anything else is to simply echo the mySQL query instead of executing it (for dubugging only of course)...

i.e...
  $query = "INSERT INTO $table (x,y,z)  VALUES ('$x','$y','$z')";
  echo $query;
This way, it will show you EXACTLY what is contained in the query.. maybe it'll help you some [/B]

i add "echo $eintragquery;"
<?
include ("config.php");
$eintragquery = "INSERT INTO $file
(filename,name,countery,inputdate,discr)
VALUES('$filename','$name','$countery','$inputdate','$discr')";

echo $eintragquery;

$result = MYSQL_QUERY($eintragquery) or die(mysql_error());
header("Location:login.php");
?>

show
INSERT INTO (filename,name,countery,inputdate,discr) VALUES('dxg1.zip','ds2012','ta','2002-10-28','abc')You have an error in your SQL syntax near '(filename,name,countery,inputdate,discr) VALUES('dxg1.zip','ds2012','ta','2002-1' at line 2

why '2002-10-28' only write the "2002-1" ?
thank!!!!

Weedpacket

Originally posted by vivi6666666
at line 2

why '2002-10-28' only write the "2002-1" ?
thank!!!!

Irrelevant - MySQL probably just truncated its error message there (you don't ask where the INSERT INTO has gone). The problem is at the other end. Now that you've echoed the query you sent to the database, do you see what is missing from it?

The_Chancer

INSERT INTO what did you say ??

Hint - $file='' or did you mean file ?