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?
No comments posted yet
Your Answer:
Login to answer
101 
14 
Other forums
PHP Mysql Staff Induction System
Hi there, I'm pretty new to PHP and Mysql so could really do with being pointed in the right directi
Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website
frame help
on the bottom frame is menu.html
Code: <body><form action='link.php' met
cPanel API
Hi Guys,
Need a little guidance. I'm trying to get my script to communicate with cPanel (or W
Snapshot from video
anyone knw how to make a snapshot maker from avi n mkv format.
for example if i give a direct lin
Remove letter from numeric textbox
I have a textbox that will search the employee database by entering in the employee ID and it will r
a very simple php header question (sorry!)
Firstly...I do apologise if this annoys anyone....a header error
I'm do not know php &
data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t
Results from Db outputted twice
Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out
DateTimeZone::listIdentifiers headache
http://php.net/manual/en/datetimezone.listidentifiers.php
So the documentation states tha
