PHP Laravel custom sort by final and better time [duplicate]

Question

i try to work this situation. i have table with results. until now i used ->orderBy('final') but i found out that is not working when i have same final time.

  Left time |  Right time  |  Final
0    24:45       24:22        24:45
1    24:85       21:84        24:85
2    24:44       25:12        25:12
3    25:12       21:78        25:12
4    38:12       25:99        38:12

problem is when i have equal final time like index [2],[3] and when is situation like that i want check better time Left time or Right time and sort them again..

so finally it must look like (index 2, 3 switch)

  Left time |  Right time  |  Final
0    24:45       24:22        24:45
1    24:85       21:84        24:85
2    25:12       21:78        25:12
3    24:44       25:12        25:12
4    38:12       25:99        38:12

You should be able to use orderByRaw() and add more than one column of sorting. Have you tried that? — thefallen
– thefallen, Commented Apr 16, 2020 at 12:46

marc_s · Accepted Answer · 2022-10-30 19:50:27Z

2

You may use the following

Model::orderByRaw("column1 DESC, column2 DESC");
    ->get();

edited Oct 30, 2022 at 19:50

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Apr 16, 2020 at 13:08

Foued MOUSSI

4,8334 gold badges21 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bilal ehsan · Accepted Answer · 2023-03-21 20:44:10Z

2

You can use orderBy multiple times.

MyTable::orderBy('column1', 'DESC')
    ->orderBy('column2', 'ASC')
    ->get();

edited Mar 21, 2023 at 20:44

answered Apr 16, 2020 at 13:13

bilal ehsan

1096 bronze badges

Collectives™ on Stack Overflow

PHP Laravel custom sort by final and better time [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related