Data sorting and stats

[madhead29]

Hi all I am wondering if there is a function(s) in php that you can count the information that mysql outputs from the database but depending on certain things?

e.g.

there is a table with 3 fields called id,ip and date after you have all the results out of the database is there anyway to could them say based on date like:

5 records with id 2 have the date "22/03/08"

so there there a function to could that there are 5 that match this?

but only using one query so that you can check for multiple dates like say there are 2 results for "23/03/08" and it will say 2 for that match and then i would display them in a table type layout.

Is there a function in php or mysql that will allow this.

Thanks.

[Krik]

First use MySQL to return resluts based on that critiera. Not to just return all the data in a table.

Second use the [man]mysql_num_rows[/man] PHP function to count those results.

There is also a way to count results in the MySQL but I am less familiar with it. For more information on that look to the MySQL manual.

[madhead29]

Thanks i will look into that