PHP - MySQL Order By

The ORDER BY Keyword

The ORDER BY keyword is used to sort the data 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.

ORDER BY PHP MySQL Syntax

SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC|DESC

ORDER BY PHP MySQL Example

The following example selects all the data stored in the "Persons" table, and sorts the result by the "Age" column:

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM Persons ORDER BY age");

while($row = mysql_fetch_array($result))
  {
  echo $row['FirstName'];
  echo " " . $row['LastName'];
  echo " " . $row['Age'];
  echo "
";
  }

mysql_close($con);
?>

The output of the code above will be:

Wayan Wenten 17
Komang Apel 16

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

PHP Ref.

References

HTML & CSS References
HTML References
HTML 5.0 References
CSS References
CSS 3 References
Browser Scripting Ref.
Javascript References
HTML DOM References
Server Scripting Ref.
PHP References

PHP - MySQL Order By

The ORDER BY Keyword

ORDER BY PHP MySQL Syntax

ORDER BY PHP MySQL Example

Order by Two Columns

PHP Ref.

References

Other Tutorials

Links

About Us

Tools

Accounts