MySQL/PHP Error #1064
I am running this SQL Query in PHP:
$activity_history_sql="INSERT into user_activity_history (user_seq, user,
timestamp, ip_address, user_request_uri, user_script_filename,
user_script_uri, user_script_url, user_script_name, user_php_self) vaues
('".$_SESSION["integradigital.co.uk"]["user_sequence"]."',
'".$_SESSION["integradigital.co.uk"]["user_forename"].'
'.$_SESSION["integradigital.co.uk"]["user_surname"]."', '".date("Y-m-d
H:i:s")."', '".$_SERVER["REMOTE_ADDR"]."', '".$_SERVER["REQUEST_URI"]."',
'".$_SERVER["SCRIPT_FILENAME"]."', '".$_SERVER["SCRIPT_URI"]."',
'".$_SERVER["SCRIPT_URL"]."', '".$_SERVER["SCRIPT_NAME"]."',
'".$_SERVER["PHP_SELF"]."') ";
but its not running it correctly. when i run the SQL in PHP My Admin i get
this:
#1064 - 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
'vaues ('', ' ', '2013-08-18 16:37:14', '89.243.11.36',
'/admin/index.php', '/hom' at line 1
but i cannot find where the error is occurring.
No comments:
Post a Comment