php - Mysql expression to select everything from a database orde by date desc -

php - Mysql expression to select everything from a database orde by date desc -

i have next database keeps jobs:

user_job(job_id, job_title, day, month, year). day, month, year fields holds expiration date each job. day holds values 1..31, month holds values january...december , year 2014...2040.

i want select * table order expiration date desc. thought how write expresion? mean want jobs expiration date desc. have tried not working:

<?php $get_jobs = mysql_query("select * `user_job` order `day`, `month`, `year` desc "); ?>

class="lang-sql prettyprint-override">select * `user_job` order `year` desc, case when `month` = 'january' 1 when `month` = 'february' 2 when `month` = 'march' 3 when `month` = 'april' 4 when `month` = 'may' 5 when `month` = 'june' 6 when `month` = 'july' 7 when `month` = 'august' 8 when `month` = 'september' 9 when `month` = 'october' 10 when `month` = 'november' 11 when `month` = 'december' 12 end desc, `day` desc

php mysql