This topic is locked

Question about sorting/order by

3/13/2006 4:45:11 AM
PHPRunner General questions
OCTheEagle author

Hi,
I have 2 questions:
1: When you press the column title , you can automatically sort the information in the database using that column (For example: order by employee). When you press that column, what is the second column the information in the table gets sorted by?
2: Is there a way so the user can manually choose on which columns he wants to ´order by´? In Microsoft Excel there is a way so the user can Order by column 3, then on column 2 , then on column 5 etc. I´m wondering if there´s a way to do this in phprunner. Offcours you can use a prebuild ´order by´ line in the ´table_variables.php´ file, but my boss wants multiple ways of ordering the information from the table.
Regards,

Sergey Kornilov admin 3/13/2006

Hi,

  1. the same records sort arbitrarily.
  2. go to the Edit SQL query Tab, click Change... and set required order.