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);
после запроса
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 }
Я получаю издателя, но не счет. Как я могу получить счет?