520435 Reporting script -- pulling from MySQL

I have a mysql database where each row stores a field with a date and a field that contains a pipe-delimited series of IDs that are associated with a contact record.

Each row is one month. There are 24 months worth of data.

I want a report created in php that will go through each month and tell me how many months each of those contact IDs is in their consecutively. (i.e. if they are in month 1, month 2, month 3, but not month 4, that would return a value of 3 for that ID).

If It's easier to have a script that creates another table based on the original table but with a row for each contact ID, then that would be an option too.

Beceriler: Her şey Kabul, MySQL, PHP, Kabuk Betiği

Daha fazlasını gör: value stores, mysql report, field reporting, data pulling, report mysql php database, mysql date field, mysql record, shell script mysql, mysql shell script, series script, php mysql database report, database reporting, mysql reporting, reporting php, contact record, php reporting, report mysql database, shell php mysql, mysql data report, php mysql reporting script, php report script, php mysql reporting, php script pipe, reporting database, php report script mysql database

İşveren Hakkında:
( 104 değerlendirme ) Mebane, United States

Proje NO: #2266372



Can be done.

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(149 Değerlendirme)