PHP display problems & nbsp; & lt; div & nbsp; title pending work items & nbsp; iconClsicon-search & nbsp; closabletrue & nbsp; & gt; & nbsp; & PHP display problems
Include ($ _ SERVER ['document _ root']. "/auth. php"); // call the database connection file
$ Query3 = "select count (*) 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 = 'under approval '";
$ Result3 = mysql_query ($ query3 );
While ($ row = mysql_fetch_array ($ result3) {// output all query results
Echo "you currently have". $ row. "pending approval process! ";
}
?>
Is this code incorrect?
------ Solution --------------------
This post was last edited by xuzuning at 09:33:02 on
Echo "you currently have". $ row [0]. "pending approval process! ";
------ Solution --------------------
$ Result3 = mysql_query ($ query3) or die (mysql_error ());
------ Solution --------------------
$ Query3 = "select count (*) 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 = 'under approval '";
Print $ query3 and put it in the database for execution to see if there are any results.