queries ( your help appreciated)

2002-03-28 Thread David Rice
I am quite new to coding and have managed so far but, i've been havin trouble with queries. Okay well here goes, it is quite simple but i can't figure it out, and haven't found any helpfull documentation I have a mysql database, and i want to sort a table by date Where the resulting records wi

Queries help (part II)

2002-03-28 Thread David Rice
Hey thanks i got it to work sort of $query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date DESC LIMIT 3"; that works but i want it to show them ascending and when i change it to $query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date ASC; DESC LIMIT 3"; it doesn't work