TheDeveloperBlog.com
C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
PHP MySQL Order By
PHP MySQL Order By for beginners and professionals with examples, php file, php session, php date, php array, php form, functions, time, xml, ajax, php mysql, regex, string, oop
PHP MySQL Order ByPHP mysql_query() function is used to execute select query with order by clause. Since PHP 5.5, mysql_query() function is deprecated. Now it is recommended to use one of the 2 alternatives.
The order by clause is used to fetch data in ascending order or descending order on the basis of column. Let's see the query to select data from emp4 table in ascending order on the basis of name column. SELECT * FROM emp4 order by name Let's see the query to select data from emp4 table in descending order on the basis of name column. SELECT * FROM emp4 order by name desc PHP MySQLi Order by Example
';
$sql = 'SELECT * FROM emp4 order by name';
$retval=mysqli_query($conn, $sql);
if(mysqli_num_rows($retval) > 0){
while($row = mysqli_fetch_assoc($retval)){
echo "EMP ID :{$row['id']} Output: Connected successfully EMP ID :3 EMP NAME : jai EMP SALARY : 90000 -------------------------------- EMP ID :2 EMP NAME : karan EMP SALARY : 40000 -------------------------------- EMP ID :1 EMP NAME : ratan EMP SALARY : 9000 --------------------------------
Next TopicPHP Interview Questions
|
Related Links:
- PHP Data Types
- PHP operators
- PHP Programs
- PHP Functions
- PHP Parameterized Function
- PHP Variable Length Argument Function
- What is PHP PDO: Tutorial, Advantages, Installation, Database Connection
- PHP Echo
- PHP Include File
- PHP Delete File
- PHP Print
- PHP Variables
- PHP $ and $$
- PHP Constants
- PHP comments
- PHP If Else
- PHP Switch
- PHP For Loop
- PHP while loop
- PHP do while loop
- PHP Call By Value
- PHP File
- PHP Call By Reference
- PHP Default Argument Values Function
- PHP MySQL Login System
- PHP Recursive Function
- PHP Array
- PHP Indexed Array
- PHP Associative Array
- PHP MongoDB Example
- PHP Multidimensional Array
- PHP Array Functions
- PHP Strings
- PHP String Functions
- PHP Form
- PHP Cookie
- PHP Session
- PHP Open File
- PHP Read File
- PHP Write File
- PHP vs. HTML
- PHP vs Node.js
- PHP vs. Python
- PHP File Upload
- PHP Download File
- PHP MVC Architecture
- PHP vs. JavaScript
- PHP Append to File
- Learn PHP Tutorial
- PHP require_once
- PHP include_once
- PHP MySQL Connect
- PHP MySQL Create Database
- PHP MySQL Create Table
- PHP Math
- PHP MySQL Insert
- PHP MySQL Update
- PHP MySQL Delete
- PHP Example
- PHP Magic Constants
- PHP break
- PHP Mail
- PHP MySQL Select
- PHP MySQL Order By
- PHP JSON
- Top 69 PHP Interview Questions (2021)