MySQL Count not functioning

Question

I'm having trouble using the COUNT function in MySQL.
Now, I searched for an answer, and the first thing I found was this, however it wanted to count each distinct value. I found this About.com page which helped me. Just making sure this isn't a duplicate, but keep reading.

I'm using MySQLi.

My code is simple, I'm trying to count the amount of times in the database, "users," that "admin" is listed as "true." Keep in mind that it's not true as in a boolean, but a string that can contain other values.

mysqli_query($con, "SELECT COUNT(*) FROM users WHERE admin='true'");

That didn't seem to work. I tried adding echo in front of the query, but I can't get the amount of times admin is true — it should echo 1.

Am I doing something wrong? I haven't found much on this subject online and I was reluctant to post it here but... I am :P
Thanks in advance!

jh314 · Accepted Answer · 2013-07-16 02:01:33Z

1

You need to fetch the results:

$result = mysqli_query($con, "SELECT COUNT(*) FROM users WHERE admin='true'");

$row = mysqli_fetch_array($result, MYSQLI_ASSOC);
printf ("%s \n", $row["COUNT(*)"]);

More info on mysqli_fetch_array can be found here.

answered Jul 16, 2013 at 2:01

jh314

27.9k16 gold badges66 silver badges83 bronze badges

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

Comments

PlausibleSarge · Accepted Answer · 2013-07-16 02:09:53Z

0

You don't need to fetch the results

$res = mysqli_query($con, "SELECT COUNT(*) FROM users WHERE admin='true'");
$number_of_rows = mysqli_num_rows($res);

according to this page

http://php.net/manual/en/mysqli-result.num-rows.php

this is untested right now

answered Jul 16, 2013 at 2:09

PlausibleSarge

2,2531 gold badge13 silver badges13 bronze badges

Collectives™ on Stack Overflow

MySQL Count not functioning

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related