php + mysql count consecutive data

Posted on 16th Feb 2014 07:03 pm by admin

I have a database of values and I want to work out how to display them if the values match a consecutive pattern.

For example, I might have the table "eggs" with the values "1", "2", "3", "4", "6", "7", "8", "9", "10". Now if I were to count these up I'd have 9 total values, this is good. What I want to do is ONLY count the values where they have another 2 consecutive values after them. So for example if the above pattern is what I'm using and I want to check for 2 consecutive values, the following would happen:

1 -> correct, it is followed by "2" and "3".
2 -> correct, it is followed by "3" and "4".
3 -> false, it is followed by "4" but no "5"
4 -> false, it is followed by "6", no"5".
6 -> correct, followed by "7" and "8".
7 -> correct, followed by "8" and "9".
8 -> correct, followed by "9" and "10".
9 -> false, followed by "10" but no "11".

and this would return the total of 7, because 7 of these values are followed by 2 consecutive numbers, therefore are correct.

So my question: How would I go about this? Would it be a matter of a single (albeit complex) mysql query or will I have to do some more advanced stuff after fetching the array? If it's the second I can do that myself, but I'd like to (hopefully) do it in a query!

So, any ideas?

Your Answer:

Login to answer

Other forums

Delete all files in folder except with certain name
I have a script that I want to delete all files in a folder (taken from a database) except for one n

If a record matches an existing record do nothing
So I don't know if I should put this here or in mysql, but what my script is for is for people to ad

The repetition structure: the while statement not working
New programming student, have assignment as follows:
A restaurant has 4 lunch combos for custom

storing video files into mysql in php
hi

i have my video files in my folder ,
i have to store the path of the videos into db an

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Display Database
I need to create a shopping cart. I found this code online: http://conceptlogic.com/jcart/
Unfort

IS Retail & Manufacturing
Hi

Can IS Retail and Manufacturing activities be done in same instance ie. in same client

unexpected T_VARIABLE error
Hey all! I'm getting an unexpected T_VARIABLE with the following function:

function getHighes

Using CSS to format MySQL query
Hi,

If i want to have a news page on my site, which displays all records of a table in descen

rdns with php
I am trying to build a script that will show all of the different domains that are hosted on the sam