order by multiple

[John mitchell]

I want to order multiple columns, with such away that it gives me the last name first & then the name & then shows the state. as shown in the following example :

Output :
Mehta Abrahim, Gujarat
Sumra Atique, Maharashtra
Shah Kevin, Maharashtra
Gada Kushal, Gujarat

[Reegan]

To get the output you require to use the following PHP Syntax

$query = "select * from table order by field2,field3,field4";

[opaper]

You are the implementation of following SQL-instructie on the aforesaid table.

SELECT * FROM `lastname` ORDER BY name ASC , state DESC