Displaying records in a cyclic fashion
Posted: Sun Jun 01, 2003 3:27 pm
How can i limit the no of records displaying from a table?To be more precisely, this is what i would like to do:
Say i've 100 records in a table.Today, I would like to show 1 to 40 records.Tomorrow from 41 to 80 and then 81 to 20 on the next day.So, something like in a cyclic fashion.
Would be glad if somebody can help me.
Many thanks
Say i've 100 records in a table.Today, I would like to show 1 to 40 records.Tomorrow from 41 to 80 and then 81 to 20 on the next day.So, something like in a cyclic fashion.
Would be glad if somebody can help me.
Many thanks