Welcome Guest, Not a member yet? Register   Sign In
consecutive days resultset from db
#1

[eluser]hyperfire[/eluser]
Hello all!

I'm trying to achieve something that's actually looking kinda hard to figure out here, any help is welcome.

I need to return a list from a specific date > 2025-01-01.
Something like:

2009-01-10 - Record X
2009-01-10 - Record Y
2009-01-10 - Record Z
2009-01-11 - No records found for this date
2009-01-12 - Record X
2009-01-12 - Record Y.... and so on...

But as in my db, the result is only giving me the dates I really have records. Like:


2009-01-10 - Record X
2009-01-10 - Record Y
2009-01-10 - Record Z
2009-01-12 - Record X
2009-01-12 - Record Y.... and so on...

What I need to do to get a consecutive result list with all dates?
Any ideas?


Messages In This Thread
consecutive days resultset from db - by El Forum - 02-02-2009, 07:57 AM
consecutive days resultset from db - by El Forum - 02-02-2009, 06:58 PM
consecutive days resultset from db - by El Forum - 02-02-2009, 09:31 PM
consecutive days resultset from db - by El Forum - 02-03-2009, 05:25 AM
consecutive days resultset from db - by El Forum - 02-03-2009, 05:56 AM
consecutive days resultset from db - by El Forum - 02-03-2009, 07:41 AM
consecutive days resultset from db - by El Forum - 02-03-2009, 10:03 AM
consecutive days resultset from db - by El Forum - 02-03-2009, 10:23 AM



Theme © iAndrew 2016 - Forum software by © MyBB