2. PHPRunner General questions
  3. SORT - multiple sorting - HOW TO?
This topic is locked

SORT - multiple sorting - HOW TO?

 		10/6/2024 4:26:06 PM
PHPRunner General questions
Z
 zwaenepoel author

I'm a using php 10.91 to create a small databaes to my car collection

I have a MAKER table, MODEL table, YEAR table, and a REFERENCE table.

I'l like to be able to sort it by MAKER, and then by year

exmple;

1 | Porsche | 911 GT2 | 1991
2 | Porsche | 911 GT3 | 1992
3 | Porsche | 911 GT2 sport | 2010
4 | Porsche | 911 GT1 sport | 1996
5 | Porsche | 911 Turbo | 1994
6 | Porsche | 911 Turbo | 1990
7 | Porsche | 911 Turbo | 1988
8 | Porsche | 911 GT1 sport | 1993

How to order them by model and then by year to have these results??

4 | Porsche | 911 GT1 sport | 1996
1 | Porsche | 911 GT2 | 1991
8 | Porsche | 911 GT1 sport | 1993
3 | Porsche | 911 GT2 sport | 2010
2 | Porsche | 911 GT3 | 1992
7 | Porsche | 911 Turbo | 1988
6 | Porsche | 911 Turbo | 1990
5 | Porsche | 911 Turbo | 1994

any help is appreciated.
H
 		headingwest 10/6/2024

On the Query tab select your table, then set Sort Type and Sort Order

img alt

HJB 10/7/2024

https://xlinesoft.com/livedemo/phprunner/livedemo7/carscars_add.php

...just for inspiration purposes only ..., it has nothing to do with sorting a
list of cars as required, but is addressing to searches for a specific car
model by year and so on. I tried to find a very old video tutorial on how
to setup such dependencies, yet it seems it is no longer on the web.
Z
 		zwaenepoel author 10/10/2024

Any help?

The suggested option is good for one time use!

But i need to have an option on my dashboard to change it according to my needs!

I already have a "level one" sorting. I need a "level two" opttion.

Like: sort by, AND THEN sort by, like filters in Excel!
Sergey Kornilov admin 10/10/2024

CTRL+click on column header? Simply mouse over the column header.

img alt