mysql_connect('127.0.0.1','root','!!!!testserv');
mysql_select_db("yhrmb") or die("无法连接到数据库");
$sql = "insert into `rmblist`
values(null,'394','firfly1126','2','好鬼','120',
'3','1','randprize','20','',
'','','16935','2009-11-24 09:13:12')";
mysql_query($sql) or die("插入失败");
这段sql语句直接用mysqladmin插入没问题.
在php语句中就不行.
不清楚如何才能看到提示错误,望高人指点一下.
mysql_select_db("yhrmb") or die("无法连接到数据库");
$sql = "insert into `rmblist`
values(null,'394','firfly1126','2','好鬼','120',
'3','1','randprize','20','',
'','','16935','2009-11-24 09:13:12')";
mysql_query($sql) or die("插入失败");
这段sql语句直接用mysqladmin插入没问题.
在php语句中就不行.
不清楚如何才能看到提示错误,望高人指点一下.
ini_set('display_errors', 1);
都试过 没报错的
$conn=mysql_connect('127.0.0.1','root','!!!!testserv');
mysql_select_db("yhrmb",$conn) or die("无法连接到数据库");
$sql = "insert into `rmblist`
values(null,'394','firfly1126','2','好鬼','120',
'3','1','randprize','20','',
'','','16935','2009-11-24 09:13:12')";
mysql_query($sql,$conn) or die("插入失败");
mysql插入数据数字不能用''