HOME | basics of HTML | basics of PHP | neobux | onbux | readbud | templates |
| |||||
PHP MySQL Order By Keyword
PHP MySQL Order By KeywordThe ORDER BY keyword is used to sort the data in a recordset. The ORDER BY KeywordThe 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
To learn more about SQL, please visit our SQL tutorial. ExampleThe following example selects all the data stored in the "Persons" table, and sorts the result by the "Age" column:
The output of the code above will be:
Order by Two ColumnsIt 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:
|
|||||
© 2011 d4download.orgfree, All Rights Reserved.
Design created by diljith d4download veriosn 2.0
HOME | basics of HTML | basics of PHP | neobux | onbux | readbud | templates |