syntax error – query useronline
-
Hi can someone explain this error to me ?
1064 – You have an error in your SQL syntax near ‘$sql[] = “CREATE TABLE $wpdb->useronline (“.
”timestampint(15) NOT NULL d’ at line 1THis is the code i got for useronline
// Create Useronline Table
$sql[] = “CREATE TABLE $wpdb->useronline (“.
”timestampint(15) NOT NULL default ‘0’,”.
”usernamevarchar(50) NOT NULL default ”,”.
”ipvarchar(40) NOT NULL default ”,”.
”locationvarchar(255) NOT NULL default ”,”.
”urlvarchar(255) NOT NULL default ”,”.
” PRIMARY KEY (timestamp),”.
” KEYusername(username),”.
” KEYip(ip),”.
” KEYfile(location))”;I’m obviously doing something wrong here but what?
Thanks advance for your help.
The topic ‘syntax error – query useronline’ is closed to new replies.