Sorting by date

[benji87]

Hey all im trying to sort a fixtures list by date! But obviously it just sorts it by first numbers for example it orders the list by day value and not day and month,

 

i found this code in a previous post

SELECT
DATE_FORMAT(date_field, '%W %M %Y')
FROM table_name

 

Trouble is i dont really understand. How do i implement that if i want to select all from the table and order it by the date???

[AndyB]

What is the exact format of the date information in your database table (oh, please let's hope it's yyyy-mm-dd)

[benji87]

Yes it is yyyy-mm-dd

[benji87]

anyone???

[AndyB]

SELECT * from tablename ORDER BY datefieldname ASC

[DeathStar]

and limit to 100 is:

SELECT * from tablename ORDER BY datefieldname ASC LIMIT 100

or to let user dicide:

$ord = "asc";
$limit = "100";

[benji87]

Ok those are pretty simpe queries and is what i already have. That wont output the date correctly as at the moment in the table its in YYYY-MM-DD format and that wont order it by the months just the number......