您的SQL语法mysqli中有错误

Question

query:

$sql .= "INSERT INTO `vip_overrides` SET `user_id` = " . $max . ", `server_id` = " . $user['server_id'] . ", `group` = '" . $user['access'] . "', `expires` = " . $user['utime'] . ", `date_create` = " . $user['time'] . "; ";

answer:

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 'INSERT INTO vip_overrides SET user_id = 1, server_id = 2, group = 'vip',' at line 1

mysqli_query dont work with multy query in one string use mysqli_multi_query

Answer 1

You cannot run multiple queries using mysqli_query.

If it's different queries, then run them separately, one by one.

If it's the same query but with different data, use a prepared statement.