Mysql Query To Sort By Two Fields ORDER By 2

this is a mysql query you can use to sort your results by order of two. this is a short tutorial that will help beginers try to use php code to query a mysql database [896], Last Updated: Tue Feb 07, 2023

wallpaperama

Mon Apr 28, 2008

2 Comments

2895 Visits

today i wanted to learn how i can order a query in a mysql database by two fields

this is how i did this

$sql = SELECT this FROM thistable ORDER BY this, andthis

NeedALongNameAsWel

Mon May 17, 2010

Thanks worked for me! What the? Comment too short? Okay so I add this...

https://www.wallpaperama.com/forums/mysql-sort-by-two-fields-order-by-2-t5986.html

Rahul

Sat Aug 29, 2009

hi, i need to use order by in other directions like : date desc and priority asc

i used this : select * from tablename where category = '1' order by date desc, priority asc limit 30

this is not working right

if use this :

select * from tablename where category = '1' order by priority, date desc limit 30

this is working but i want date desc first then priority asc, how to do this please help

rahul

Free PHP OPen Source Shopping Cart Open Source Script

Mysql Query To Sort By Two Fields ORDER By 2

Related Pages