PHP Mysql find how many results it got

[Joveice]

Hi, so I need a script that "select uid from user where team=somename".

In this database there are 3 users,

uid - jack, team - hello.

uid - river, team - hello.

uid - alex, team - no.

 

so when it runs the select to get all the usernames that has team hello in it I want it to return a number, in this case "2".

How can this be done?

[corrado33]

I believe the keyword you are looking for is "count"

[Joveice]

1 minute ago, corrado33 said:

I believe the keyword you are looking for is "count"

Yea but how can I use this for the mysql returns?

[vorticalbox]

1 minute ago, Joveice said:

Yea but how can I use this for the mysql returns?

http://www.w3schools.com/sql/sql_func_count.asp

[corrado33]

I believe it's just "select count(*)"

[vorticalbox]

2 minutes ago, corrado33 said:

I believe it's just "select count(*)"

SELECT COUNT(players) where team='home';

 

that should di assuming you have the table called players and the column called team.

[Joveice]

8 minutes ago, vorticalbox said:

SELECT COUNT(players) where team='home';

 

that should di assuming you have the table called players and the column called team.

Thank you, works perfectly.

[mariushm]

You should also look into functions like mysql_num_rows()  and similar .. ex for the mysqli class http://php.net/manual/en/mysqli-result.num-rows.php

 

select count(*) is not always accurate.

[Joveice]

1 minute ago, mariushm said:

You should also look into functions like mysql_num_rows()  and similar .. ex for the mysqli class http://php.net/manual/en/mysqli-result.num-rows.php

 

select count(*) is not always accurate.

Noted, since I do use MySQLi.