help ordering by date

[webguy262]

Trying to find events prior to today's date, and order them chronologically, either asc or dsc.

 

Here's what I've got, but they display out of order.

 

What am I missing?

 

$today = date("Ymd");

$query = "SELECT title, link, chapter, DATE_FORMAT(start_date, '%M %d,
%Y') AS start_date, DATE_FORMAT(start_date, 'Ymd') AS chrono, city, state
FROM events_calendar WHERE start_date < $today  order by chrono";

[PFMaBiSmAd]

The format string in the following is not valid - DATE_FORMAT(start_date, 'Ymd') AS chrono, but that whole term is unnecessary. Also, I am not sure what the results of using an alias of start_date when there is a column by that name would be.

 

What is the format of your start_date column - DATE or DATETIME?

 

Once I know what start_date is, I can show you a very simple query to do what you want.

[webguy262]

Thanks for helping!

 

start_date is DATE

[PFMaBiSmAd]

This should give the same results -

 

$query = "SELECT title, link, chapter, DATE_FORMAT(start_date, '%M %d,
%Y') AS date, city, state
FROM events_calendar WHERE start_date < CURDATE() order by start_date";

 

Your can use ORDER BY with a DATE type directly and CURDATE() (and CURRENT_DATE, CURRENT_DATE()) give you the date directly (no need for any slow php code.)

[webguy262]

Works perfectly!  Thanks!