Go Back   Wiki NewForum > Career Forum > Tech Forum & Tutorial > PHP Forum & Tutorial

PHP Forum & Tutorial PHP Tutorial, Codes, Examples & Full End-To-End Process

Reply
Views: 1800  
Thread Tools Rate Thread Display Modes
  #1  
Old 05-04-2009, 05:52 PM
welcomewiki welcomewiki is offline
Member
 
Join Date:
Dec 2008
Location:
India
Posts: 65,834
Default PHP MySQL Order By Keyword

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


Syntax

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

Reply With Quote
  #2  
Old 05-04-2009, 05:53 PM
welcomewiki welcomewiki is offline
Member
 
Join Date:
Dec 2008
Location:
India
Posts: 65,834
Default

Example

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




$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:




Glenn Quagmire 33
Peter Griffin 35
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
Reply With Quote
Reply

New topics in PHP Forum & Tutorial

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.