PHP display problems
Is this code incorrect?
Reply to discussion (solution)
Echo "you currently have". $ row [0]. "pending approval process! ";
No syntax error in the code
Please describe your problems
This is a small page to be processed. After debugging, data cannot be loaded, and no output result is returned for the number of $ row entries.
Echo "you currently have". $ row [0]. "pending approval process! ";
No, it's always loading data.
$ Result3 = mysql_query ($ query3) or die (mysql_error ());
$ Result3 = mysql_query ($ query3) or die (mysql_error ());
Er, I still cannot.
Please make it clear what problems you have encountered
$ 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.
The SQL statement output is 1.
$ 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.
The SQL statement output is 1.
This is a p layer on the home page. now this code cannot output the result, so the whole page is being loaded and cannot be displayed.
Get an echo in the front of auth. php and test it ......
Debugging is done by yourself. thank you!