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.