var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Displaying records in a cyclic process
I have 100 records in a table and I would like to show 1 to 40 today and 41 to 80 tomorrow and 81 to 20 the next day.so, something like in cyclic process.
How should i write my sql query??
You could precisely specify the limit clause to return the range of rows you want, controlled by what ever programming language your system is using.
Or, I don't know if functions are permitted with LIMIT, but if so, using a MySQL date function, with a calculation, might be a better way to go.