This topic is locked

Newest Addition

4/26/2009 12:33:54 PM
PHPRunner General questions
W
wilsonhaze author

Hi,

How would you suggest i create a page that shows the most recent entries when the page loads.

Thanks.

O
OLDmrcaseyman 4/26/2009

Hi,

How would you suggest i create a page that shows the most recent entries when the page loads.

Thanks.


What I do is include a datetime field in my table that I call "Created_On".

In the visual editor I make this a read only field and in the default value box I put: now()

So each time a record is added it gets the date and time placed into the field.

Then in the Query editor I sort on this Create_On field in descending order (DSC).

Newest records are at the top on the resulting list page
Hope that helps,
Steve