- or download this
$insertData = "INSERT INTO url_Connect (sourceIP
dt tm, remoteIP) VALUES ($sourceIP, $date,
...
$dbMake = $dbi->prepare($insertData);
$dbMake->execute(); #<-----line 86
- or download this
DBD::mysql::st execute failed: You have an error in your SQL syntax; c
+heck the manual that corresponds to your MySQL server version for the
+ right syntax to use near 'dt, tm, remoteIP) VALUES (192.168.1.1, 23
+/Mar/2008,
04:02:02, 77.91.224.1' at line 2 at createDB.pl li
+ne 86
- or download this
my $createTable = "CREATE TABLE IF NOT EXISTS
url_Connect(
...
tm time,
remoteIP varchar(16)
)";