consecutive days resultset from db

consecutive days resultset from db

El Forum
Guest

02-03-2009, 10:23 AM

[eluser]hyperfire[/eluser]
Another idea witch just popped out here, is to create a table with all dates till 2024 (the end of the world LOL), get the date of the last 'event' trough one little select, then generate the second select from the selected start date, trough the last date returned form the first one, and do the pagination for those records. Is this ugly as it looks like?
Maybe its less resource intensive that creating this table all the time, since its a kinda portal website.

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