Welcome Guest, Not a member yet? Register   Sign In
how to access the count(*) property?
#10

[eluser]Chad Fulton[/eluser]
[quote author="jmadsen" date="1264754428"]Uh, Phil...


the number of rows returned is not the same as count(*)


"SELECT count(*) `count` FROM table WHERE ..."

->num_rows() is 1
$row->count is how ever many rows meet the where clause...

Maybe you want to read the post? ;-)[/quote]

Maybe it's you who ought to read the post Wink

Although you make a good point in the case you talk about, if you read the first post, you'll notice that he's selecting the count(*) along with other variables, which means the count(*) number will be the same as the number of rows.


Messages In This Thread
how to access the count(*) property? - by El Forum - 01-21-2010, 11:45 PM
how to access the count(*) property? - by El Forum - 01-22-2010, 12:25 AM
how to access the count(*) property? - by El Forum - 01-22-2010, 12:53 AM
how to access the count(*) property? - by El Forum - 01-22-2010, 12:56 AM
how to access the count(*) property? - by El Forum - 01-22-2010, 12:58 AM
how to access the count(*) property? - by El Forum - 01-22-2010, 03:33 AM
how to access the count(*) property? - by El Forum - 01-22-2010, 04:02 AM
how to access the count(*) property? - by El Forum - 01-22-2010, 07:09 AM
how to access the count(*) property? - by El Forum - 01-28-2010, 08:40 PM
how to access the count(*) property? - by El Forum - 01-28-2010, 09:11 PM
how to access the count(*) property? - by El Forum - 01-28-2010, 09:58 PM
how to access the count(*) property? - by El Forum - 01-29-2010, 12:31 AM
how to access the count(*) property? - by El Forum - 01-29-2010, 03:35 AM
how to access the count(*) property? - by El Forum - 01-29-2010, 04:18 AM
how to access the count(*) property? - by El Forum - 02-07-2010, 06:59 PM



Theme © iAndrew 2016 - Forum software by © MyBB