MySQL datetime problem

martinlk

Hi all

I'm new to MySQL and I'm having trouble doing the following:

I've built a database containing concerts - each row contains the place, time & date (the datetime datatype), and description.

Let's say that the database is full of data - both past and upcoming concerts. I then only wan't to display the concerts that are relevant for the current date and after - not past concerts! Keep in mind that even though a concert is scheduled at 9 pm and the time is 10 pm I still wan't it displayed.
In short: I don't wan't to select concerts for the previous day and older.

Please help me, what is a possible query string for this -- The site is due finished a week ago 😕

superwormy

Your Query:

SELECT * FROM concerts WHERE datetime > '2003-15-00 00:00:00'

martinlk

yes, but that is not quite what i was looking for. The site is a bandsite that amongst other things features concertdates and times. So the only relevant information would be concerts scheduled the current day or in the future. Your example sets a static date that works as a delimiter - I wan't to select the concerts that are played the current day or in the future...

I hope you understand what i'm getting at (english is not my native language)...

superwormy

Sorry, I figured you could read the fricking manual and figure the rest out yourself... but thats OK, I have all the time in the world are am glad to do all the work for you :-)

www.php.net/date
http://www.mysql.com/doc/en/Date_and_time_functions.html

$query = "SELECT * FROM concerts WHERE datetime > '" . date ("Y-m") . "-00 00:00:00'";

martinlk

ok, I'm gonna ignore your insult and say thank you VERY MUCH! Keep in mind that I'm very drunk right now and unable to think for myself! Wait a minute, what am I doing in front of the computer? WUUUUUUUUUUUUUUUUHUUUUUUUUUUU!

Thanks again - let's all be friends! Sometimes the world KICKS ASS!

superwormy

Hehe relax wasn't an insult, just jokign around :-)

No problem, glad to help :-)

martinlk

O.K. You saved my ass!

btw the site im working on is this one. Check out the mp3s if you like indie rock!