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

php web service error
hey guys,
I'm working on a project requires the use of web services. I've been trying a few tutor

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

UPLOAD IMAGES NOT WORKING!
Hi there i have a upload script in which it uploads the picture to a folder than creates two thumbna

Help with form post data and arrays
Hi all,

I am new to this forum... It has been awhile since i have worked with arrays, and i a

PHP Login
Hey!
I got this shopcart code online, am trying to modify it but am getting an error when i try a

JSON SORT WITH PHP
I have two products that I want to sort by say "Id:17, value: xxx" using php
The page w

some query on multilingual website
Hi all,

Which is the simplest and easiest method to make a website multilingual,
is it put

Page not Loading After Test
Hey All

It seemed that an inlcude statement wasn't working for some reason, so I tried a more

asp authentication problem
Hello all, I want to use the asp authentication (from asp.net configuration) in my web site. there

PHP login form help (Done Most of It)
Hi i am having a problem, when i try logging in it is always saying "Invalid Login" im not