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.

snippet
SELECT * FROM emp4 order by name

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

snippet
SELECT * FROM emp4 order by name desc

PHP MySQLi Order by Example

Example
snippet
 0){
 while($row = mysqli_fetch_assoc($retval)){
    echo "EMP ID :{$row['id']}  
". "EMP NAME : {$row['name']}
". "EMP SALARY : {$row['salary']}
". "--------------------------------
"; } //end of while }else{ echo "0 results"; } mysqli_close($conn); ?>

Output:

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 --------------------------------
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +