title: Solving count query issue
body: <p>I have the following code where i need to select all items from personabisna table and count items with the same personalbisnaId from another table where the both tables share the personalbisnaid</p>
  
  <pre><code> $query="select c.BusinessLogo,
                      c.PersonalBisnaId, 
                      c.account_id,
                        AS Ads from personalbisna As c INNER JOIN myads AS b on b.PersonalBisnaId=c.PersonalBisnaId GROUP BY c.PersonalBisnaId LIMIT $itemfrom,$dataperpage";
  </code></pre>
  
  <p>These are the tables</p>
  
  <p>Personalbisna table</p>
  
  <pre><code>| PersonalBisnaId| account_id| BusinessLogo
  ---------------------------------------------
  |       1         |   23     |  qwertyu.jpg
  |       2         |    4     |  asdfghjk.jpg
  |       3         |   12     |  34567gfd.jpg
  |       4         |   34     |   drtyujhv.jpg
  </code></pre>
  
  <p>myads table</p>
  
  <pre><code>|   MyAdsId       | PersonalBisnaId| AdType
  ---------------------------------------------
  |       1         |     2           |  logo
  |       2         |     2           |  business card
  |       3         |     3           |  logo
  |       4         |     2           |   caricalture
  </code></pre>
  
  <p>I have used some already answered questions to solve my problem and i'm really getting totally confused to solve my issue</p>
  
  <p>The above query should output the following</p>
  
  <pre><code>| PersonalBisnaId| account_id| BusinessLogo      | AdsCount
  -------------------------------------------------------
  |       1         |   23     |  qwertyu.jpg      |  0
  |       2         |    4     |  asdfghjk.jpg     |  3
  |       3         |   12     |  34567gfd.jpg     |  1  
  |       4         |   34     |   drtyujhv.jpg    |  0
  </code></pre>
  
  <p>This what i have</p>
  
  <pre><code>$query="SELECT  
                  c.BusinessLogo,
                  c.PersonalBisnaId, 
                  c.account_id,
                  c.BusinessName,
                  c.BusinessCategory,
                  c.BusinessSubCategory,
                  c.town,
                  c.estate,
                  c.street,
                  c.road,
                  c.building,
                  c.Address,
                  c.city,
                  c.PhoneNumber,
                  c.AltPhoneNumber,
                  c.website,
                  c.Email,
                  c.BusinessType              
                  COUNT(MyAdsId)  AS AdsCount
                  FROM   personalbisna AS c 
                  LEFT OUTER JOIN myads AS b 
                  ON  b.PersonalBisnaId= c.PersonalBisnaId 
                  GROUP BY  c.PersonalBisnaId LIMIT $itemfrom,$dataperpage";
  </code></pre>