www.pickatutorial.com Computer Tutorials
Top Tutorials: C/C++ | C#.NET | PHP MySQL | Java | Java Script | jQuery | HTML | xHTML | HTML5 | VB Script| CSS
Lessons MySQL ORDER BY Bookmark and Share
Lesson 1
Lesson 2
Lesson 3
Lesson 4
Lesson 5
Lesson 6
Lesson 7
Lesson 8
Lesson 9
Lesson 10
Lesson 11
Lesson 12
Lesson 13
Lesson 14
Lesson 15
Lesson 16
Lesson 17
Lesson 18
Lesson 19
Lesson 20
Lesson 21
Lesson 22
Lesson 23
Lesson 24
Lesson 25
Lesson 26
Lesson 27
Lesson 28
Lesson 29
Lesson 30
Lesson 31
Lesson 32
Lesson 33
Lesson 34
Lesson 35
Lesson 36
Lesson 37
Lesson 38
Lesson 39
Lesson 40
Lesson 41
Lesson 42
Lesson 43
Lesson 44
MySQL Order By Keyword
The ORDER BY keyword in MySQL is used to sort the data in a recordset. It sorts the records in ascending order by default. If our needs are different, we us the DESC keyword to sort the recordset in descending order. Its syntax follows:

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


Example
The following example selects / retrieves all the data from the "Students" table, and sorts the result by the "Age" column in ascending order:

<?php
$con = mysql_connect("localhost", "adam" ,"ada");
if (!$con)
{
die('Error connecting database');
}mysql_select_db("my_db", $con);
$result = mysql_query("SELECT * FROM Students ORDER BY age");
while($row = mysql_fetch_array($result))
{
echo $row['name'];
echo " " . $row['age'];
echo " " . $row['address'];
echo "<br />";
}
mysql_close($con);
?>


Order by multiple columns

Similarly we can order the recordset on more than one column. Its syntax follows:

SELECT column_name(s)
FROM table_name
ORDER BY column1, column2, column3



Home - Advertise - Contact - Disclaimer - About Us
© Since 2006 pickatutorial.com -- All Rights Reserved.