PHP 5 MYSQL order clause
How to used order clause
Order by clause is basically used for sorting the record in PHP MYSQ.(descending or ascending order).
Syntax of order by clause
SELECT *FROM table_name
ORDER BY column_name(s) ASC|DESC
The given query fetch selected record in that table
SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) ASC|DESC
FROM table_name
ORDER BY column_name(s) ASC|DESC
Where ASC is used for Aascending and DESC is used for descending order.
Example of order by
<?php
$user = "root";
$pwd = "";
$host = "localhost";
$db = @mysql_connect($host,$user,$pwd) or die("Connection failed");
mysql_select_db("my_db1") or die ("could not select the database");
echo "connection estsblished<br>";
$query="SELECT *from student
ORDER BY name DESC";
$a=mysql_query($query,$db) or die("Execution of query failed!!!");
if(! $a )
{
die('Could not get data: ' . mysql_error());
}
echo "====================";
while($row = mysql_fetch_array($a))
{
echo "<br>Name :{$row['name']} <br> ".
"Branch: {$row['branch']} <br> ";
}
echo "====================";
echo"<br>Query Fetched";
mysql_close($db);
?>
Output
connection estsblished
====================
Name :xyz
Branch: ma
Name :harry
Branch: cse
Name :Brown
Branch: Ece
====================
Query Fetched
====================
Name :xyz
Branch: ma
Name :harry
Branch: cse
Name :Brown
Branch: Ece
====================
Query Fetched
Another example of order by
<?php
$db = @mysql_connect("localhost","root","");
mysql_select_db("my_db1");
$query="SELECT name from student
ORDER BY name ASC";
$a=mysql_query($query,$db) or die("Execution of query failed!!!");
if(! $a )
{
die('Could not get data: ' . mysql_error());
}
echo "====================";
while($row = mysql_fetch_array($a))
{
echo "<br>Name :{$row['name']} <br> ";
}
echo "====================";
mysql_close($db);
?>
Explanation
mysql_error() function is used to display the mysql error.
