PHP's MySQL ORDER by command keyword

PHP's MySQL ORDER by command keyword

Command keywords are used to sort data records.


The keyword for this command
Command keywords are used to sort data records.

The command keyword sort records are sorted in ascending order by default.

If you want to sort the records in a descending order, you can use the keyword description.

Grammar

SELECT column_name (s) from table_name ORDER by
column_name (s) asc| DESC

 
   
   

    
     To learn more about SQL, visit our SQL tutorial. 
    
    
 
    
    
 For example, 
    
    
 The following example selects all the data stored in the people table, resulting in a variety of "age" columns: 
    
    
 
    
    
   
 
    
    
 $con = mysql_connect ("localhost", "Peter", " Abc123 "); if (! $con) {die (' could not connect: '. Mysql_error ());} mysql_select_db ("my_db", $con); $result = mysql_query ("SELECT * from Persons"); while ($row = Mysql_fetch_array ($result)) {echo $row [' FirstName ']; echo "". $row [' LastName ']; echo "". $row [' age ']; echo "<br/>"; 
 
    
    
 mysql_close ($con); 

  
    
    
   

  
    
    
 output to. 
 
    
    
 
 Glenn Quagmire Griffin 
 
   
 
 
      
      
 
       
       
 Command two Column 
 is also possible with more than one column. When ordering more than one column, the second column is used only for value if the first column is equal: 
 
       
       
   
 
       
       
 SELECT column_name (s) from table_name orders by Column1, Colu Mn2 
 
       
       
 Reprint please indicate from: www.111cn.net/database/database.html