How to order by date in mysql

[numerical25]

Im trying to figure out how to order by date from present to past in mysql. I came across post that showed how to do it like this.

$select_query="SELECT cust_id,DATE_FORMAT(startdate, '%m-%d-%Y')AS startdate,DATE_FORMAT(postdate, '%m-%d-%Y')AS postdate,zipcode, startdate as sortdate from drental ORDER BY sortdate DESC;

But I want to select ALL from the table. so how would I implement something like above, trying to select all rows from the table

[bretticus]

numerical25;10877822 wrote:

But I want to select ALL from the table. so how would I implement something like above, trying to select all rows from the table

Use the asterisk to specify all columns

$select_query="SELECT * from your_table ORDER BY your_date_column DESC";

[thepeccavi]

I think you wants to select all rows, and I think that is what you are doing!!

Isaac

PS. If you want to loops through and display the whole lot as a table or process it etc. just use a while loop (google it!)