PHP MySQL Order By - Rookie Nerd

PHP Tutorial

Install PHP

How to run PHP code in XAMPP

PHP Echo

PHP Print

PHP echo and print Statements

PHP Variables

PHP Variable Scope

PHP $ and $$ Variables

PHP Constants

Magic Constants

PHP Data Types

PHP Operators

PHP Comments

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