How to fetch row count in PHP in Mysql Database? [duplicate]

Question

$count = mysql_query("SELECT COUNT(id) FROM users");

echo $count;

This is not working . Error message Resource id Unknown #21.
how to fix this ?

Community · Accepted Answer · 2023-11-17 20:29:45Z

7

$count = $db->query("SELECT COUNT(id) FROM users");

Should be

$count = $db->query("SELECT COUNT(id) FROM users")->fetchColumn();

echo $count; //Returns number of rows

CommunityBot

11 silver badge

answered Jan 31, 2014 at 13:20

Mr. Alien

158k36 gold badges307 silver badges287 bronze badges

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

1 Comment

i am not using PDO. Msql connection is used.

z.a.a · Accepted Answer · 2015-02-01 08:54:33Z

-1

use this mysql_num_rows

$sql=mysql_query("SELECT COUNT(id) FROM users");
$count= mysql_num_rows($sql);
echo $count ;

answered Feb 1, 2015 at 8:54

z.a.a

1

This answer is wrong as it will return 1 every time it is called