PHP 顯示有關問題

來源:互聯網
上載者:User
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列印出來放到資料庫去執行看看有沒有結果
  • 聯繫我們

    該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

    如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.