推 littlex:sql 語法寫錯字 mac.ip ?? mac,ip 10/29 23:53
推 showsky:我我恍然大悟我眼睛脫脫....窗了謝謝 10/30 00:05
寫了一個維修系統
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