[SOLVED] Count how many rows

[clay1]

I have a query which selects all the rows matching a market and then displays how many results there were

 

I need to be able to break that down to display how many total results, and how many were under a certain age

 

Do I need to do a separate select statement? Or can I use something like pg_num_rows to count how many are under age 25?

[mikesta707]

what does your code currently look like?

 

but you could just  iterate throughthe rows. While you iterate, you have several tests, and update several counters based on that test. for example

 

//sql stuff above
$arr = array();
$count = 0;
$count1 = 0;
$count2 = 0;
while($row = mysql_fetch_assoc($query)){
$count++;
if ($row['age'] < 25){
$count2++;
}
#etc
}

 

[clay1]

That would work

 

Would there be a better way than looping through and counting?

[mikesta707]

not that I could see. you will have to loop through anyways to get the data regardless so its not adding much more stuff for the script to do

[clay1]

Cool, thanks

[Philip]

What does your current select statement look like? Processing it on the db side is typically more efficient

[shane18]

Try:

 

$rowcount = mysql_num_rows(mysql_query("SELECT NULL FROM TABLENAME WHERE COLUMNNAME < 25"));

[clay1]

I'm selecting all from table where market =

 

I'm using just a simple count as suggested to this now

 

It's working

[The Little Guy]

mysql_query("SELECT 
(SELECT COUNT(age) FROM snippets WHERE age = '25') as age25,
(SELECT COUNT(age) FROM snippets WHERE age = '30') as age30
WHERE market = 'some value'");

[cunoodle2]

mysql_num_rows()