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
TinyMCE / Ajax Postback Problem
Hiya all,
I have a page which loads the TinyMCE editor. On the postback I obviously want to f
SAP Project Module
I have seen in the SAP Project Module,plan cost and budget are not equal and even difference is sign
how to make database item unique
Hey guys,
is it possible to do this:
I have the database item $title being pulled for
[function.file]: failed to open stream: No such file or directory
Okay I wrote this little script to upload a csv file that is located on my webhosts server to a mysq
sapgui f4 help last search
I know this has to be simople. One user (maybe more) does not have the "last search saved" from the
Convert array to string and write to csv file
I am looking to write a MySQL query to a csv file.
At the minute I:
check for the orig
Remore client postprocessing phase getting dump SAPSQL_ARRAY_INSERT_DUPREC
Hello Expects,I have started remore client copy. Data was copied successfully. but while running pos
adding 0 to numbers
Hey guys i need to create a 00001 number in a loop. Is there a better way of forcing a 5 digit numbe
Login Script Issues
I am using a script I got from http://phpsense.com/php/php-login-script.html in order to allow peopl
need help with date function
i have following form for date
Code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01
