[PHP/MySql] Sorting After Select

[iamcameron]

Hello, My name is Cameron, I have searched the internet for a solution, but i can only find how to sort a mysql Select command when running the SQL command.

I need to reverse a mysql result of 20 rows but i don't know how i would do it, Here is my current SQL command

$select=mysql_query("SELECT * FROM table_name ORDER BY id DESC LIMIT 20");

This selects the last 20 rows in the table_name table starting from the last

I need to reverse the result so the last row select is now first, but i dont know how i could do this, Any Ideas?

~~Thanks, Cameron

 

[slacker3]

what happens when you leave out "DESC" ?

as far as i know this keyword already reverses your result
(but i'm no SQL guru )

 

[vishal]

Hello, My name is Cameron, I have searched the internet for a solution, but i can only find how to sort a mysql Select command when running the SQL command.

I need to reverse a mysql result of 20 rows but i don't know how i would do it, Here is my current SQL command

$select=mysql_query("SELECT * FROM table_name ORDER BY id DESC LIMIT 20");

This selects the last 20 rows in the table_name table starting from the last

I need to reverse the result so the last row select is now first, but i dont know how i could do this, Any Ideas?

~~Thanks, Cameron

Remove LIMIT ,Limit is used to show particular num of rows .In ur case desc works perfectly and also limits it by 20 so ur r getting only last 20.
Here is a syntax

The syntax for an ORDER BY statement is as follows:
SELECT "column_name"
FROM "table_name"
[WHERE "condition"]
ORDER BY "column_name" [ASC, DESC]

 

[descalzo]

Lacks error checking and using mysql_XXX rather than mysqli_XXX or PDO:

$select=mysql_query("SELECT * FROM table_name ORDER BY id DESC LIMIT 20");
$results = array() ;
while( $one_row=  mysql_fetch_array ( $select  ) ){
   $results[] = $one_row ;
}
$results = array_reverse( $results ) ;

$results should be an array of arrays in the order you want.