[討論]phpmyadmin可執行的query在php卻會錯誤
phpmyadmin可執行下列SQL查詢
update history set comment=concat(comment,'<a href="detail" target="_blank">
查詢流程</a>') WHERE `status_id`=1 and comment LIKE '%結果 : Succeeded.%'
and `date_added`>= curdate()
但相同語法置於.php執行會出現錯誤
<?php
$username="username";
$password="password";
$dbname="database";
$dbhost="localhost";
$query="update history set comment=concat(comment,'<a href="detail" target
="_blank">查詢流程</a>') WHERE `status_id`=1 and comment LIKE '%結果 :
Succeeded.%' and `date_added`>= curdate()";
mysql_connect($dbhost,$username,$password);
@mysql_select_db($dbname) or die(strftime('%c')." Unable to select database");
mysql_query($query);
mysql_close();
echo strftime('%c')." ok!";
?>
還請各位版大指教～感謝！
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 211.74.64.49
※ 文章網址: https://www.ptt.cc/bbs/Database/M.1513418170.A.525.html
推
12/16 22:45,
6年前
, 1F
12/16 22:45, 1F
→
12/17 05:15,
6年前
, 2F
12/17 05:15, 2F
→
12/17 10:23,
6年前
, 3F
12/17 10:23, 3F
→
12/17 10:24,
6年前
, 4F
12/17 10:24, 4F
→
12/18 01:37,
6年前
, 5F
12/18 01:37, 5F
→
12/18 01:45,
6年前
, 6F
12/18 01:45, 6F
→
12/18 01:56,
6年前
, 7F
12/18 01:56, 7F
→
12/18 11:16,
6年前
, 8F
12/18 11:16, 8F
推
12/18 22:36,
6年前
, 9F
12/18 22:36, 9F