· 8 years ago · Jun 27, 2018, 02:40 PM
1Error: 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 'CREATE TABLE `admin_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` ' at line 2
2
3
4---
5
6
7<?php
8$createTables = mysql_query("
9DROP TABLE IF EXISTS `admin_logs`;
10CREATE TABLE `admin_logs` (
11 `id` int(11) NOT NULL AUTO_INCREMENT,
12 `user_id` int(11) DEFAULT NULL,
13 `action` text,
14 `dtime` datetime DEFAULT NULL,
15 PRIMARY KEY (`id`)
16) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
17?>