Query Return Only One value In Count php and mysql [duplicate]

Question

hi guys the query only return one rows even i have 12 rows. Please help

$connection = mysqli_connect("localhost","root","","database");
$qry="SELECT COUNT(*) as count FROM table";
$result=mysqli_query($connection, $qry);

COUNT is an aggregation function, it's going to aggregate all rows unless you use groupings. — Devon Bessemer
– Devon Bessemer, Commented Aug 17, 2018 at 16:53
You dont actually get the information that that query returns. You need to do some sort of fetch to get the actual count — RiggsFolly
– RiggsFolly, Commented Aug 17, 2018 at 17:29

Gordan Lin · Accepted Answer · 2018-08-17 16:57:30Z

-2

As Devon mentioned, COUNT is an aggregate function, so it will only return 1 row. If you want to retrieve all 12 rows, do:

SELECT * FROM table;

answered Aug 17, 2018 at 16:57

Gordan Lin

371 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1