2. PHPRunner General questions
  3. List page order
This topic is locked

List page order

 		11/4/2009 4:32:32 PM
PHPRunner General questions
greggk author

I'm doing a simple vertical list one column so the records on the list page show up vertically one at a time. My question is, how can I get the last record to show up on top? So each time a new record is added, that record is shown first in the list page.
J
 		Jane 11/5/2009

Hi,
to sort records on the page add ORDER BY statement to the SQL query on the Edit SQL query tab.

Here is a sample:

select field1,

field2,

...

from TableName

Order by field1 desc



More info here:

http://www.xlinesoft.com/phprunner/docs/query_designer.htm