2. PHPRunner General questions
  3. How to make the newest record to apear first!
This topic is locked

How to make the newest record to apear first!

 		9/19/2007 1:15:20 PM
PHPRunner General questions
I
 Idol author

Hi,
I was wondring how to make the last added record to come first on the List page!
My list page record look like this
ID.nr:

1 ..... ....... ......

2 ..... ....... ......

3 ..... ....... ......

4 ..... ....... ......
I want my list page to look like this:
ID.nr

4 ..... ....... ......

3 ..... ....... ......

2 ..... ....... ......

1 ..... ....... ......
Last came first!...could some one help? thanks...
Sergey Kornilov admin 9/19/2007

Choose to sort data by ID field in descending order.
"SQL query" tab in PHPRunner.
I
 		Idol author 9/19/2007

Choose to sort data by ID field in descending order.

"SQL query" tab in PHPRunner.


Yes,
and what is the written formula for it?
my ID's Field name is "pecasdecarros5ID"
And should it be written in the field with the name "ORDER BY on the list page"?...on the "SQL query" page!?...right?
K
 		kjp 9/19/2007



Yes,
and what is the written formula for it?
my ID's Field name is "pecasdecarros5ID"
And should it be written in the field with the name "ORDER BY on the list page"?...on the "SQL query" page!?...right?


If your table is welldone, only with 5 clicks..
Sergey Kornilov admin 9/20/2007

kjp,
wow, one picture says it better than thousand words.

Thanks for helping with this one!
I
 		Idol author 9/20/2007

If your table is welldone, only with 5 clicks..


Kjp,
That worked beautifuly!
I am thankful to you!

Have a greate day!