Count data from table SQL

Question

my query:

           "SELECT id
            FROM user_follow
            WHERE user_id IN(3,6) AND follow_id NOT IN(3,6)
            GROUP BY follow_id";

and it show :

[users] => Array
    (
        [0] => Array
            (
                [id] => 20
            )

        [1] => Array
            (
                [id] => 9
            )

        [2] => Array
            (
                [id] => 19
            )

    )

I need to count data (in this example query must give back 3 as result)

I tried COUNT(id) but result was not good for me.

result :

        [0] => Array
            (
                [count(id)] => 1
            )

I tried SELECT count(1)

result :

        [0] => Array
            (
                [count(1)] => 1
            )

        [1] => Array
            (
                [count(1)] => 2
            )

        [2] => Array
            (
                [count(1)] => 1
            )

Still not not one number (3). I want something like this [users] => 3

What do you mean by the "result was not good"? Did you get an error? Was not the correct number? — jprofitt
– jprofitt, Commented Jan 29, 2012 at 0:14
Drop the GROUP BY then.... and just SELECT COUNT(DISTINCT id) — Wrikken
– Wrikken, Commented Jan 29, 2012 at 0:15
I can't drop GROUP BY follow_id because of stackoverflow.com/questions/9049401/… this group prevent of showing the duplicate friends — Viktors
– Viktors, Commented Jan 29, 2012 at 0:35

Mike · Accepted Answer · 2012-01-29 00:23:37Z

2

If you need only the number and not the data itself you can try this:

SELECT count(1)
FROM user_follow
WHERE user_id IN(3,6) AND follow_id NOT IN(3,6)
GROUP BY follow_id

answered Jan 29, 2012 at 0:23

Mike

3,0241 gold badge37 silver badges47 bronze badges

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

4 Comments

Viktors Over a year ago

I want to get back only one number (for example 3)

Viktors Over a year ago

I tried your query, do not show one number. result is something like count(id)

Viktors Over a year ago

I have post example with SELECT count(1)

Viktors Over a year ago

your link techonthenet.com/sql/count.php help me ! Thank you very much

Mert Emir · Accepted Answer · 2012-01-29 00:15:19Z

1

$count=mysql_num_rows($sql);

you can try this

answered Jan 29, 2012 at 0:15

Mert Emir

6912 gold badges8 silver badges20 bronze badges

Comments

user1062893 · Accepted Answer · 2012-01-29 00:18:05Z

1

if I am understanding your need, you can use count on the array itself as follows :

                $count=count($users)

answered Jan 29, 2012 at 0:18

user1062893

891 silver badge6 bronze badges

Collectives™ on Stack Overflow

Count data from table SQL

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related