How do you each the value Count(id)?

[onedumbcoder]

select count(id) from user WHERE age > 33

 

 

now when i execute that query how to i echo that value?

$result = mysql_query('select count(id) from user WHERE age > 33');
$count = mysq_fetch_array($result);

echo $count[???];

[Maq]

Read: http://www.tizag.com/mysqlTutorial/mysqlcount.php

[cbolson]

Hi,

you can do it like this:

$result = mysql_query('select count(id) AS total from user WHERE age > 33');
$count = mysq_fetch_array($result);

echo $count["total"];

 

Chris

[onedumbcoder]

try this

 

 

 

$result = mysql_query("select id AS total from user WHERE age > 33");
echo mysql_num_rows($result);

[onedumbcoder]

try this

 

 

 

$result = mysql_query("select id AS total from user WHERE age > 33");
echo mysql_num_rows($result);

 

Thanks so much, that did it.

[corbin]

Don't do it like that.  I don't feel like getting into the details, but that pulls all of the rows and then counts them.  If you only care how many rows there are, get MySQL to send back that.

 

 

$q = mysql_query("SELECT COUNT(blah) FROM bleh");

$r = mysql_fetch_row($q);

echo $r[0];

[onedumbcoder]

off topic, but corbin are you by any chance racist? I got that eerie feeling reading your post.

 

[Maq]

off topic, but corbin are you by any chance racist? I got that eerie feeling reading your post.

 

 

Please elaborate.  What in his post suggest racism?

[fenway]

I can't see this ending well.