Re: newbie MySQL question

On Sat, 19 May 2001, Matt Nigh wrote: > hi, i'm building a website right now with a shows page on it which will > scroll horizontally in a window. i have each show listed in a table called > shows (db is called almavale_board) with the following fields: > > id - bandplaying - venue - date - time - cover - description you could put the band info in another table and reference them by bandid or something. this would make it easier to expand, like if you ever wanted to collect stats on each band (like members, genre, etc.). i only mention this because i did a calendar of events page a while back and eventually went to such a format. it is much easier this way because each event was only listed in the database once. just a thought... > what i need to do is have the shows listed by date, having the latest date > listed first. here's the code i have presently: > > [ code snip ] > > oh and the date is in this format : Month-Day-,Year (ex. May 19, 2001) > > if anyone can help me out on this at all (or has any questions about my > problem), please reply to this post, i'd be very appreciative. how is the date column defined in mysql... is it a DATE type? ... if so the date would look something like 2001-05-19 in mysql, and you could use something like: SELECT DATE_FORMAT(date, '%M %d, %Y'), ... FROM shows ORDER BY date DESC and mysql would sort and format the date as necessary. like this: mysql> select DATE_FORMAT(date, '%M %d, %Y') from dates order by date desc; +--------------------------------------+ | DATE_FORMAT(date, '%M %d, %Y') | +--------------------------------------+ | March 31, 2001 | | March 29, 2001 | | March 28, 2001 | | March 28, 2001 | | March 27, 2001 | | March 24, 2001 | ... hope this helps... :)