| Author |
Message |
RoanokeREALTOR
Joined: 08 Jun 2007 Posts: 6
|
Posted: Thu Jul 12, 2007 11:50 am Post subject: how do I design my web page so that the oldest news goes to |
|
|
| I want it so that only 10 entries are entered on the main page and whenever I enter a new entry, the previous entries get moved down and the 10th entry gets put in the next page? thank you. |
|
| Back to top |
|
 |
Freethinker
Joined: 19 Sep 2005 Posts: 2
|
Posted: Sun Jul 29, 2007 1:31 pm Post subject: how do I design my web page so that the oldest news goes to |
|
|
| In the sql statement, add ORDER BY col_name DESC col_name - is a col_name in your table (most probably news_id, in your case). |
|
| Back to top |
|
 |
Conan-------
Joined: 17 Apr 2007 Posts: 4
|
Posted: Wed Aug 15, 2007 3:12 pm Post subject: how do I design my web page so that the oldest news goes to |
|
|
| "order by date desc;" will make the news items ordered by descending date order but it will not transfer the oldest entry to the next page.Interesting problem. I shall think and contact u if I find some soln...But u don't allow emails....... |
|
| Back to top |
|
 |
|