Mysqli Count Two Data Type in one query

Question

I have a chart script. To know usage I have made a mysql column named first_load. When user visits the page it draws default pie chart. So, if user load the chart by default one entry gets inserted Yes. If use enters his/her preferred data and draw the chart then query inserted No. If I would like to check how many times users loaded the chart for the first time and with user's data. Is it possible to do it in one query? Instead of selecting the table first_load where = yes and no separately and counting the row?

My intention in here to reduce the query.

I can't figure out anything except two different queries

$YesData="Yes";
$NoData="No";
$yesquerys= sprintf("SELECT first_load from 'analytics' where first_load='%s'",$mysqli_real_escape_string($conn,$YesData));
$noquerys= sprintf("SELECT first_load from 'analytics' where first_load='%s'",$mysqli_real_escape_string($conn,$NoData));

I can't think of anything except using two different queries one for yes and another for no. like SELECT first_load FROM analytics where first_load="Yes" and another separate for no. — DAKSH, Nov 27 '16 at 05:31
Have you written any code? If you have I am sure that community here at SO would love to help you out. — Teddy Codes, Nov 27 '16 at 05:51

score 1 · Accepted Answer · edited May 23 '17 at 11:52

1

I found the answer MySQL: Count occurrences of distinct values I didn't know if we can count occurrences.

So, it would be

SELECT first_load,COUNT(*) as count FROM `analytics` GROUP BY first_load ORDER BY count DESC

edited May 23 '17 at 11:52

Community

1
1

answered Nov 27 '16 at 06:35

DAKSH

460
1
5
22

Mysqli Count Two Data Type in one query

1 Answers1