[Resolved] Displaying records in a cyclic process

minds_gifts

Hello everybody,

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??

Many thanks

weekender

//set day = 1, 2, 3 or whatever...
$day = 2;

//with day=1, sets lowerlimit to 21, upper to 40
$lowerlimit = ($day * 20) - 19;
$upperlimit = $day * 20;

//limit string is now LIMIT 21, 40
$limit = "LIMIT $lowerlimit, $upperlimit";

//SQL now returns those rows specified in limit
$sql = "SELECT * FROM table WHERE 1 $limit";

minds_gifts

sounds really complicated.
First i limit the rows to 10, becuase i use the previous and next links for the pages.

I have no idea if this limit collides with the limit i use to display the records each day.

My pagination script works pretty good, so i would prefer not changing.Any other ideas??

Thanks

jeremuck

I don't know what your requirements are, but if it were me, I'd put a field in the database that tells me when to show it. Then you just tack a clause onto the where statement like daytoshow.table = $today .

If you posted some code, maybe someone could help you out a bit more. And here's another piece of advice: be careful to so blunty reject others solutions, especially when you haven't taken the time to try and figure it out.

minds_gifts

Hello everybody,

I figured out the solution for this one, here it is......

First, i got the weekday with this piece of code:

$today = getdate(); 
$day = $today['weekday'];

and now i used switch statement in order to execute the query based on the weekday, something like:

switch($day) 
{ case "Monday": 
$query="SELECT introtext,zipcode,image,telephone,description FROM tbl_personals ORDER BY id Limit 5,6"; 

$numresults=mysql_query($query,$connection); 
$numrows=mysql_num_rows($numresults); 
break; 
//and so on with the other cases.... 
}

Thats it, aint it simple?🙂