Keyword Order By MySQL PHP

ORDER BY aiki na kai tsamman guraben kowane guraben aikin yadda ake kammala.

ORDER BY aiki na kai

ORDER BY aiki na kai tsamman guraben kowane guraben aikin yadda ake kammala.

Yanar Gizo

SELECT column_name(s)
FROM table_name
ORDER BY column_name

Rarrabe:SQL ba ya da matsakaici ga tsawon harabci. ORDER BY yana da wajibci daya da order by.

Tarihin

Ranararar a hanyar "Persons" tabben, kuma a karrama kiyara ga "Age" cikin kiyar da yadda ake kammala:

<?php
$con = mysql_connect("localhost","peter","abc123");
bango baiwa!
  {
  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 "<br />";
  }
mysql_close($con);
?>

Output of the above code:

Glenn Quagmire 33
Peter Griffin 35

Ascending or descending sorting

If you use ORDER BY keyword, the default sorting order of the record set is ascending (1 before 9, "a" before "p"):

Please use DESC keyword to set descending order (9 before 1, "p" before "a"):

SELECT column_name(s)
FROM table_name
ORDER BY column_name DESC

Ita ce za a ƙirga da mutummutan biyu

Ita ce za a ƙirga da mutummutan kula. Idan a ƙirga da mutummutan kula, kisan farko ne ke amfani, kamar yadda yake a ƙirga mutummutan farko:

SELECT column_name(s)
FROM table_name
ORDER BY column_name1, column_name2