没有计数从这个查询通过mysqli_fetch_object

Question

this is my query for count value and its count

echo $getq2 = "SELECT publisher,COUNT(publisher) from (select publisher from wiley where $getq2_ UNION ALL SELECT publisher FROM elsevier WHERE $getq2_ UNION ALL SELECT publisher FROM sage WHERE $getq2_  UNION ALL SELECT publisher FROM indianjournal WHERE $getq2_) as publisher Group by publisher order by publisher";

$getquery1 = $conn->query($getq2); 
after the query fetching through

while($runrows =mysqli_fetch_object($getquery1))
   {
      print_r($getquery1);

      echo $pub=$runrows->publisher;
      //getting the publisher list
      echo $count=$runrows->count['publisher'];
      //not grtting the publisher count
 }

I'm getting the publisher, but not the count. How can I get the count? result is getting properly

Answer 1

change the query to like this.

echo $getq2 = "SELECT publisher,COUNT(publisher) as publisherCount from (select publisher from wiley where $getq2_ UNION ALL SELECT publisher FROM elsevier WHERE $getq2_ UNION ALL SELECT publisher FROM sage WHERE $getq2_  UNION ALL SELECT publisher FROM indianjournal WHERE $getq2_) as publisher Group by publisher order by publisher";

and use echo $pub=$runrows->publisherCount to get publisher count