Count specific errors in a database [RESOLVED]
Posted: Mon Jul 05, 2010 3:25 pm
Hi Guys,
I am new to Mysql & PHP and don't know exactly what function I should be looking at for this.
I have a database of some 1 million records, there is one field in the database that contains an error code. I need to search through all records and count the amount of individual errors.
EXAMPLE:
----------------
Field name -> event_desc
ErrorManager.storeError(): name:7725878458375 time: Tue Jun 03 12:59:19 EDT 2010 code: 9909 data:667,D,555,345345354
I need to somehow read the "code: 9909" and count the total amount of them that exist between a specified date range in the database. There are also multiple other error numbers that need to be counted as well.
Any help would be greatly appreciated.
Thanks,
I am new to Mysql & PHP and don't know exactly what function I should be looking at for this.
I have a database of some 1 million records, there is one field in the database that contains an error code. I need to search through all records and count the amount of individual errors.
EXAMPLE:
----------------
Field name -> event_desc
ErrorManager.storeError(): name:7725878458375 time: Tue Jun 03 12:59:19 EDT 2010 code: 9909 data:667,D,555,345345354
I need to somehow read the "code: 9909" and count the total amount of them that exist between a specified date range in the database. There are also multiple other error numbers that need to be counted as well.
Any help would be greatly appreciated.
Thanks,