How To Retrieve Record in Ascending or Descending Order in PHP?

How To Retrieve Record in Ascending or Descending Order in PHP? 

To retrieve record in ascending or descending order in php ORDER BY clues use.

Rows which retrieved from the table will be sorted in either ascending or descending order.

Syntax:

SELECT * FROM tablename ORDER BY columnname, columnname[sort order];

Example:-

Retrieve from emp table in ascending order of employee name

SELECT * FROM emp ORDER BY empnm;

In descending order

SELECT * FROM emp ORDER BY empnm DESC;

SBI Specialist Posts Exam Admit Cards 2014 Declare sbi.co.in

NDRI 15 Research Associates 2014 Recruitment ndri.res.in

Paradip Port Trust Odisha Marine Pilots Recruitment 2014paradipport.gov.in

IIIT Faculty Recruitment 2014 iiita.ac.in

HSL 105 Various Recruitment 2014 hsl.gov.in

Mail Motor Service 17 Driver Recruitment 2014 davp.nic.in

CSIR Dhanbad 02 Project Assistant Recruitment cmriindia.nic.in

IGM Hyderabad 32 Technician Recruitment igmhyderabad.spmcil.com

ECHS 12 Staff 2014 Recruitment echs.gov.in

APPSC Specialist Doctors 2014 Recruitment appsc.gov.in