trainingtrains Logo

91-9990449935

 0120-4256464

PHP MySQL Order By

PHP mysql_query() function is used to execute select query with order by clause. Since PHP 5.5, mysql_query() function is deprecated. Now it is recommended to use one of the 2 alternatives.

  • mysqli_query()
  • PDO::__query()

The order by clause is used to fetch data in ascending order or descending order on the basis of column.

Let's see the query to select data from emp4 table in ascending order on the basis of name column.

Let's see the query to select data from emp4 table in descending order on the basis of name column.

PHP MySQLi Order by Example

Example

Output:

Connected successfully
EMP ID :3 
EMP NAME : jai 
EMP SALARY : 90000 
--------------------------------
EMP ID :2 
EMP NAME : karan 
EMP SALARY : 40000 
--------------------------------
EMP ID :1 
EMP NAME : ratan 
EMP SALARY : 9000 
--------------------------------