On Saturday 19 October 2002 00:09, NIPP, SCOTT V (SBCSI) wrote:
> I am trying to tweak an application that I have developed. The
> application is our "On-Call Log". This application consists of three
> pages; one page to input new entries, one page to edit existing entries,
> and finally a log view page. The log view page displays all entries for
> the past 5 days. The display of the entries is formatted properly, and
> presented chronologically with the oldest first with 10 items per page.
> This is exactly what I want. The one thing that I want to change is that
> the log defaults to displaying the "first" page containing the oldest
> items. I would like the log to display exactly as it does, but default to
> displaying the last page first. This way we see the most recent items
> first.
> I hope this makes sense, and following is what I think are the
> relevant sections of the code:
One quick fix is to just display the items in reverse order so the newest
items are always first ...
> { some code snipped }
> mysql_select_db($database, $Prod);
> $query_entry = "SELECT * FROM oncall WHERE TO_DAYS(NOW()) - TO_DAYS(ptime)
> <=5 ORDER BY 'ptime' ASC";
... change the ASC to DESC should do the trick.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Yow! Did something bad happen or am I in a drive-in movie??
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
