PHP 顯示問題
include($_SERVER['DOCUMENT_ROOT']."/auth.php");//調用資料庫連接檔案
$query3 = "select count(*) from (select * from (select * from bydms_dutyapp where dutyapp_approverid='$MY_SYSNUMBER' order by dutyapp_datetime desc ) as bydms_tempa left join bydms_project on dutyapp_projectid=project_id ) as bydms_tempb where dutyapp_result='審批中' ";
$result3 = mysql_query($query3);
while ($row = mysql_fetch_array($result3)) { //輸出所有的查詢結果
echo "您當前有".$row."條待審批次程序!";
}
?>
這段代碼有錯嗎?
------解決方案--------------------
本帖最後由 xuzuning 於 2014-03-04 09:33:02 編輯
echo "您當前有".$row[0]."條待審批次程序!";
------解決方案--------------------
$result3 = mysql_query($query3)
or die(mysql_error());
------解決方案--------------------
$query3 = "select count(*) from (select * from (select * from bydms_dutyapp where dutyapp_approverid='$MY_SYSNUMBER' order by dutyapp_datetime desc ) as bydms_tempa left join bydms_project on dutyapp_projectid=project_id ) as bydms_tempb where dutyapp_result='審批中' ";
把$query3列印出來放到資料庫去執行看看有沒有結果