Syntax error at line 1

Asked Jul 13 '15 at 18:33

Active Jul 13 '15 at 18:42

Viewed 34 times

Why i have this error?

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 '22:59:45,5.122.42.79,logged in to BanTools)' at line 1 [1064]

@$log = "1";
$act = "logged in to BanTools";
$a = "Ramin";

if($log == "1" ) { 
$visit = Array(
'username'     => $a,
'ctime'         => date("Y-m-d H:i:s"),
'ip_address'   => $_SERVER['REMOTE_ADDR'],
'action'       => $act
);

$sql = "INSERT into act_log (".join(',', array_keys($visit)).") VALUES (".join(',', array_values($visit)).") ";

$db->sql_query($sql);  
$db->sql_close();
}

edited Jul 13 '15 at 18:42

Jay Blanchard

34,243
16
77
119

asked Jul 13 '15 at 18:33

MaxDome

You need to quote text that you are inserting. – AbraCadaver Jul 13 '15 at 18:34
my text has quote like this $a = "Ramin"; but also have this error can you tell me true way with an example on my source cod than you. – MaxDome Jul 13 '15 at 18:40

Syntax error at line 1

0 Answers0