PHP MySQL Query Use ORDER BY

PHP MySQL SELECT Use ORDER BY

In the SELECT statement can use the ORDER BY to order the return select statement.

Syntax

• Return the SELECT statement order by the first_name.
• ORDER BY DESC (use order by descending:Z-A or largest to the smallest), it default option when not define.
• ORDER BY ASC (use order by ascending:A-Z or smallest to the largest)

$sel_query = 'SELECT first_name, 
	          last_name 
		FROM student 
		ORDER BY first_name ';

$result = mysql_query($sel_query, $connection); 

Example 1

<?php

define('HOST', 'localhost');
define('USER', 'root');
define('PASS', 'yeething');
define('DBNAME', 'woowood');

$connection = mysql_connect(HOST, USER, PASS);

if (!$connection) {
	die("can not connect to the server!<br/>");
} else {

	$rdb = mysql_select_db(DBNAME);
	if (!$rdb) {
		die("The " . DBNAME . "database could not be selected");
	} else {
		$sel_query = 'SELECT first_name, 
			             last_name 
				FROM student 
				ORDER BY first_name';

		$result = mysql_query($sel_query, $connection) 
                     or die(mysql_error($connection));
		echo '<table border="1">';
		echo '<tr><th>First Name</th><th>Last Name</th></tr>';
		while ($row = mysql_fetch_assoc($result)) {
			echo '<tr>';
			foreach ($row as $value) {
				echo '<td>' . $value . '</td>';
			}
			echo "</tr>";
		}
		echo '</table>';
	}
}
mysql_close($connection);
?> 

Output

Related Links

• PHP and MySQL Tutorial
• PHP Tutorial
• Tutorial Home

---

1. MySQL Connect
2. Create Database
3. Connect to Database
4. Delete Database
5. Create Table
6. Insert Record
7. Insert From Array
8. Insert From File
9. Update Record
10. Query Single Record
11. Query Multiple Records
12. Query Uses LIMIT
13. Query Uses ORDER BY
14. Delete Table

1. Create Two Tables for this section tutorial
2. Query Uses AND Operator
3. Query Uses OR Operator
4. Query Uses INNER JOIN
5. Query Uses LEFT OUTER JOIN
6. Query Uses RIGHT OUTER JOIN
7. Query with Subquery

1. MySQL Aggregate Count
2. MySQL Aggregate SUM
3. MySQL Aggregate MAX
4. MySQL Aggregate MIN
5. MySQL Aggregate AVG
6. MySQL Query Uses GROUP BY
7. MySQL Query Uses Having

1. PHP MySQL Create Date
2. PHP MySQL Insert Date
3. PHP MySQL Query Date