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