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

MS are the best!!!
Visit http://www.microsoft.com/australia/windows/default.aspx?h=watch-a-demo and click the massive '

SMTP server...
I recently found a tutorial online on SMTP authentification for sending emails from webpages, here i

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

Save remote XML to local website folder
Hi, I hope you can help me out. I would like to be able to pull an XML file from another site and t

Count of reciepients in php mailer
How can i sent a mail to large no of reciepients say 10,00,00 Using PHP MAILER

output printing as hexadecmal... XD
Everything works except the calcem call for the totusold and totuprice. The out put shows up as hex.

Last Weeks sDate and eDate.
sDate - Start Date
eDate - End Date

I need to pull two dates for "Last Week" whi

Calculating n! using vector
#include
#include
#include

using

modifying query string with no page refresh
Hi everybody,
I've tried to get info about my problem all over the internet but i didn't find out

Turning Data into URLs?
This may seem very basic to you, but I'm having a hard time figuring out how to do this since I don'