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

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

github - Teamcity & Git - PR merge builds - anyway to get HEAD commit hash? -

ios - Replace text in UITextView run slowly -