[請益] MYSQL 寫入問題
寫了一個維修系統
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
推
10/29 23:53, , 1F
10/29 23:53, 1F
推
10/30 00:05, , 2F
10/30 00:05, 2F
討論串 (同標題文章)