MySQL查询工作,但不是在服务器
问题描述:
我在PHP安装主登录系统,它可以完美运行在XAMMP但在服务器它注册页面给出错误:MySQL查询工作,但不是在服务器
“有误,请重试!”
if(($db->query("INSERT INTO `".MLS_PREFIX."users` SET ?u", $user_data)) && ($id = $db->insertId()) && ($db->query("INSERT INTO `".MLS_PREFIX."privacy` SET `userid` = ?i", $id)) && ($db->query("INSERT INTO `".MLS_PREFIX."privacy1` SET `chart` = '1', `vip` = '1', `userid` = ?i", $id))) {
$page->success = 1;
$_SESSION['user'] = $id;
$user = new User($db);
} else
$page->error = "There was an error ! Please try again !";
答
唐不包括在backtics点;正确的语法是:
`dbname`.`tablename`
hello Sid bro,any solution? –