[Resolved] Field Error

[Sharif]

I have a field titled 'message_date' which is a DATE field. I try to run a query on it:

SELECT id, DATE_FORMAT(date, '%m/%d/%y') AS message_date, message, first_name FROM staff ORDER BY first_name DESC

I get this error:

Unknown column 'date' in 'field list'

What's up?

[steadyguy]

Switch around the 'date' and the 'message_date' in your query:

SELECT id, 
    DATE_FORMAT(message_date, '%m/%d/%y') AS date, 
    message, 
    first_name 
FROM staff 
ORDER BY first_name DESC