How to write PHP script by using ORDER BY clause inside it to sort the data of MySQL table?

MySQLMySQLi Database

We can use the similar syntax of the ORDER BY clause into the PHP function – mysql_query(). This function is used to execute the SQL command and later another PHP function – mysql_fetch_array() can be used to fetch all the selected data.

To illustrate it we are having the following example −

Example

In this example, we are writing a PHP script that will return the result in descending order of the authors of the tutorial −

<?php
$dbhost = 'localhost:3036';$dbuser = 'root';
$dbpass = 'rootpassword';$conn = mysql_connect($dbhost,$dbuser, $dbpass); if(!$conn ) {
die('Could not connect: ' . mysql_error());
}
$sql = 'SELECT tutorial_id, tutorial_title, tutorial_author, submission_date FROM tutorials_tbl ORDER BY tutorial_author DESC'; mysql_select_db('TUTORIALS');$retval = mysql_query( $sql,$conn );

if(! $retval ) { die('Could not get data: ' . mysql_error()); } while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) { echo "Tutorial ID :{$row['tutorial_id']} <br> ".
"Title: {$row['tutorial_title']} <br> ". "Author: {$row['tutorial_author']} <br> ".
"Submission Date : {$row['submission_date']} <br> ". "--------------------------------<br>"; } echo "Fetched data successfully\n"; mysql_close($conn);
?>
Updated on 22-Jun-2020 14:18:23