php - How to display count information to page -
I have created a query to select and count specific fields from a table and query the query from the second table with the name Corisepending
Example
Item name for showing the results on page that works when I run it in SQL on localhost, but how it works. Count tieme name 2 - count here is the query
$ objects-> Connect (); // calculation question $ countQuery = 'SELECT a.isubId', b. `SIBID`, b. 'TBL_Lit`,' TBLSBs 'B WHERE a.IsubId `= B.`` SIBID Group By A`IISIIIBID'; from SUUTTile`, COUNT (A. CivilId`); // Query $ Objects- & gt; Run query ($ countQuery); I will show results on page
First your function < Code> $ objects- & gt; Query ($ countQuery); The result will be returned back to the array that you can get:
$ result = $ objects-> Query ($ countQuery); and then apply the $ loop to the result; Yes add as COUNT (a.subId) cnt as well and then resonance result $ [0] -> gt ; Cnt; Depending on your return array format.
Comments
Post a Comment