Chronological order of data base on the date

That's strange. It dosen't stop the loop. How many pages did you get? More than 3 I take it?
Just for the sake of it. Try your code and delete the extra <tr> inside your if statements. In case I made an error on my if statement.

Now it's working sir. Remove the extra tr and td. But the problem is that now my first page is limited to 10 entries the 2nd page got 19 and the last page is 5 which it could be only to pages only. I would like to have 18 entries on the 1st page and this would be arrange by date. The oldest date would be the 1st entry and so on. Waiting for your help sir. Thanks in advance.