PHP MySQL Use ORDER BY

Select and Order Data From a MySQL Database

Choose and arrange information from a MySQL database

The ORDER BY clause is used to put the results in ascending or descending order.

By default, the ORDER BY clause puts the records in order from least to most. Use the DESC keyword to sort the records from most important to least important.

SELECT columnname(s) FROM tablename ORDER BY columnname(s) ASC|DESC

Visit our SQL tutorial to learn more about SQL.

Select and Order Data With MySQLi

MySQL lets you choose and sort data.

In the next example, the student table’s id, firstname, and lastname columns are chosen. The last name column will be used to sort the records:

Example

<?php
$servername = “localhost”;
$username = “username”;
$password = “password”;
$dbname = “school”;

// Create connection
$link = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$link) {
die(“Connection failed: ” . mysqli_connect_error());
}

$sql = “SELECT id, firstname, lastname FROM student ORDER BY lastname”;
$result = mysqli_query($link, $sql);

if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
echo “id: ” . $row[“id”]. ” – Name: ” . $row[“firstname”]. ” ” . $row[“lastname”]. “<br>”;
}
} else {
echo “0 results”;
}

mysqli_close($link);
?>

Output

id: 3 – Name: ajay das
id: 1 – Name: ram lal
id: 2 – Name: shyam lal

People also search
Scroll to Top