作者showsky (小小世界)
看板PHP
标题[请益] MYSQL 写入问题
时间Sun Oct 29 23:41:21 2006
写了一个维修系统
http://www.dwu.edu.tw/web95/pctool.php
网址如上
写进去会出现Column count doesn't match value count at row 1
找了好久都不知道哪错误?
$A = mysql_connect("localhost","XXXXX","XXXXX") or die(mysql_error());
$B = mysql_select_db("fixsystem") or die(mysql_error());
$tt = date("Y-m-y");
$name = $_POST["name"];
$tel = $_POST["tel"];
$classno = $_POST["classno"];
$dep = $_POST["dep"];
$home = $_POST["home"];
$port = $_POST["port"];
$mac = $_POST["mac"];
$ip = $_POST["ip"];
$question = $_POST["question"];
$p = "INSERT INTO
pctool(date,name,tel,classno,dep,home,port,mac.ip,question,unit1,unit2)
VALUES
('$tt','$name','$tel','$classno','$dep','$home','$port','$mac','$ip','$question','NULL','NULL')";
mysql_query($p,$A) or die(mysql_error());
echo "OK" ;
?>
找了好久还是一样头痛了照书本那样打也是@@
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 218.172.126.50
1F：推 littlex:sql 语法写错字 mac.ip ?? mac,ip 10/29 23:53
2F：推 showsky:我我恍然大悟我眼睛脱脱....窗了谢谢 10/30 00:05