[請益] PHP網頁更改資料庫資料
$name = $_POST['name'];
$add = $_POST['add'];
$pharmacy_key=$_POST['pharmacy_key'];
$area=$_POST['area'];
$city=$_POST['city'];
$tel=$_POST['tel'];
$tel2=$_POST['tel2'];
$issue_date = $_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
$sql="UPDATE pharmacy SET time='$issue_date', area='$area', city='$city',
name='$name', add='$add', tel='$tel', area='$tel2' WHERE
pharmacy_key='$pharmacy_key'";
mysql_query($sql);
我的SQL語法哪裡有錯>"<都沒辦法更改或新增
如果
$sql="UPDATE pharmacy SET time='$issue_date' WHERE
pharmacy_key='$pharmacy_key'";
到這裡就可以更改時間~~可是在往下寫下去~~就沒辦法了~~
到底出甚麼問題>"<
請求~"~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.120.247.4
→
04/05 11:30, , 1F
04/05 11:30, 1F
→
04/05 11:51, , 2F
04/05 11:51, 2F
→
04/05 11:52, , 3F
04/05 11:52, 3F
→
04/05 12:15, , 4F
04/05 12:15, 4F
→
04/05 12:15, , 5F
04/05 12:15, 5F
→
04/05 12:42, , 6F
04/05 12:42, 6F
→
04/05 12:46, , 7F
04/05 12:46, 7F
→
04/05 14:00, , 8F
04/05 14:00, 8F
→
04/05 14:01, , 9F
04/05 14:01, 9F
→
04/05 18:09, , 10F
04/05 18:09, 10F
→
04/05 18:10, , 11F
04/05 18:10, 11F
推
04/06 00:34, , 12F
04/06 00:34, 12F
→
04/06 00:40, , 13F
04/06 00:40, 13F
討論串 (同標題文章)
完整討論串 (本文為第 1 之 2 篇)：
1
13
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
