title: select count and other records in one single query
body: <p>I have the following query</p>
  
  <pre><code>select main_cat_name,cat_url from mf_main order by main_cat_name
  </code></pre>
  
  <p>This returns whole data of my table.Now i want to have count of the total rows of this table.I can do it using another query but how can i use them in one single query???</p>
  
  <p>I want two data ONE :- the rows of the table TWO:- the count
  how can i have that in one single query</p>
  
  <p>I tried this but it gives correct count but displays only first row of the table :</p>
  
  <pre><code>select count(cat_id),main_cat_name,cat_url from mf_main order by main_cat_name
  </code></pre>