mysql_query("insert into ".$tableName." (id,name,telephone) values ('$counters[0]','$counters[1]','$counters[2]')");
打印你的sql,看输出什么东西
Error: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 ''0101' (id,name,telephone)values('1','王刚','19011224442 ')' at line 1 session_start();也写了
表名不用加单引号 直接输出sql语句看下就知道错在那了
输出:insert into '0101' (id,name,telephone)values('1','王刚','19011224442 ')
mysql_query("insert into `$tableName` (id,name,telephone) values ('$counters[0]','$counters[1]','$counters[2]')");
$tableName=$_SESSION['msg'];
mysql_query("insert into".$tableName." (id,name,telephone) values('$counters[0]','$counters[1]','$counters[2]')");
为什么还有错误呢?
session_start();也写了
谢谢你,按照你说的们果然调试出来了,
$tableName=$_SESSION['msg'];
$sql =mysql_query('set names utf8');
mysql_query($sql);
$sql="insert into $tableName (id,name,telephone)values('$counters[0]','$counters[1]','$counters[2]')";