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: Sat May 18, 2024

wallpaperama

Mon Apr 28, 2008

2 Comments

2896 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...

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

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

Free PHP OPen Source Shopping Cart Open Source Script

Mysql Query To Sort By Two Fields ORDER By 2

Related Pages