Sorting using PHP MySQL ORDER BY Statement

Sorting using MySQL ORDER BY Statement

We use Sorting using MySQL  Order by statement in a recordset.The ORDER BY keyword sort the records in ascending order by default.

If you want to sort the records in a descending order, you can use the DESC keyword.

SELECT column_name(s)

FROM table_name

ORDER BY column_name(s) ASC|DESC

You can sort on multiple columns, and you can sort different columns in different directions

This query would return me the results ordered by the species in the order I need and then sort it by column_name

For Example

The following example selects all the data stored in the “student” table, and sorts the result by the “Age” column:

<?php
$con = mysql_connect(“localhost”,”username”,”password”);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
mysql_select_db(“schooldatabase”, $con);
$result = mysql_query(“SELECT * FROM student ORDER BY age”);
while($row = mysql_fetch_array($result))
{
echo $row['FirstName'];
echo ” ” . $row['LastName'];
echo ” ” . $row['Age'];
echo “<br />”;
}
mysql_close($con);
?>

 

The output of the code above will be:

Garry Kristen 25

Jhon Don 22

 

Order by Two Columns

It is also possible to order by more than one column. When ordering by more than one column, the second column is only used if the values in the first column are equal:

SELECT column_name(s)

FROM table_name

ORDER BY column1, column2

you can also sort with php function like sort, ksort etc

Related Posts


Leave a Reply

Your email address will not be published. Required fields are marked *


*