How to specify sort field??

well, after this question has been out there for around 2 months without any replies I give up on the product. Iron Speed may be more expensive but at least one can get a support answer???? See ya

The SQL standard does not explicitly define a default sort order for Nulls. ... Vendors who do not implement this functionality may specify different ... if that field contains Null, but, in fact, such expressions return Unknown now a days i am doing mcse please pray for me

James,
this is not a support forum.
To get guaranteed reply from support team in 24 hours open ticket at http://support.xlinesoft.com.

I have the same question about setting the sort order. I found this but I'm not how to use it in phprunner.
So far, we have seen how to get data out of a table using SELECT and WHERE commands. Often, however, we need to list the output in a particular order. This could be in ascending order, in descending order, or could be based on either numerical value or text value. In such cases, we can use the ORDER BY keyword to achieve our goal.
The syntax for an ORDER BY statement is as follows:
SELECT "column_name"

FROM "table_name"

[WHERE "condition"]

ORDER BY "column_name" [ASC, DESC]
The [] means that the WHERE statement is optional. However, if a WHERE clause exists, it comes before the ORDER BY clause. ASC means that the results will be shown in ascending order, and DESC means that the results will be shown in descending order. If neither is specified, the default is ASC.
It is possible to order by more than one column. In this case, the ORDER BY clause above becomes
ORDER BY "column_name1" [ASC, DESC], "column_name2" [ASC, DESC]
Assuming that we choose ascending order for both columns, the output will be ordered in ascending order according to column 1. If there is a tie for the value of column 1, we then sort in ascending order by column 2.
For example, we may wish to list the contents of Table Store_Information by dollar amount, in descending order:
Table Store_Information

store_name Sales Date

Los Angeles $1500 Jan-05-1999

San Diego $250 Jan-07-1999

San Francisco $300 Jan-08-1999

Boston $700 Jan-08-1999
we key in,
SELECT store_name, Sales, Date

FROM Store_Information

ORDER BY Sales DESC
Result:
store_name Sales Date

Los Angeles $1500 Jan-05-1999

Boston $700 Jan-08-1999

San Francisco $300 Jan-08-1999

San Diego $250 Jan-07-1999
In addition to column name, we may also use column position (based on the SQL query) to indicate which column we want to apply the ORDER BY clause. The first column is 1, second column is 2, and so on. In the above example, we will achieve the same results by the following command:
SELECT store_name, Sales, Date

FROM Store_Information

ORDER BY 2 DESC
so where do I put this code? I want to sort the project id in ascending order for all of my pages.

Is this in the query area?

wbdesigner.
you can add ORDER BY clause to SQL Query on 'SQL Query' screen in PHPRunner.
Post PHPRunner questions in PHPRunner forum.

I tried adding

ORDER BY "Project ID" DESC
to the end of the query and it ignored it
Got it in phprunner you just check the box for sort order.. DUH it's to easy.