[SOLVED] query tomorrow

[dadamssg]

Im trying to set a query to select events that are gonna happen tomorrow...as in always the next day, the whole 24 hr period. i have the code below to query todays events, how can i set that up to query for tomorrow?

 

$quer = "SELECT * FROM test WHERE DATE(start) <= CURDATE() AND DATE(end) >= CURDATE() ORDER BY start DESC";	

 

I doubt theres a tomorrow date function like the curdate()...any help would be amazing, thanks

[Mchl]

CURDATE() + 1

 

 

[dadamssg]

wow, that simple? awesome thank you very much

[Mchl]

emm... no... that returns silly results for the last day of month

 

20090132

[Mchl]

try

 

SELECT * FROM test WHERE DATEDIFF(start,CURDATE()) = 1 AND DATEDIFF(end,CURDATE()) = 1 ORDER BY start DESC

[dadamssg]

thanks i will as soon as my hosting service lets me login! 

[dadamssg]

worked beautifully thank you, i have a database full of events...start, end, title, and then event type(sports, music, etc.) how would i make that same query only pull up the event type of say music??? the column in the database is called eventtype

[dadamssg]

ehh i take that back...it pulled up events starting and ending on tomorrows date but didn't pull up anything in between...ie an event that started yesterday and ended feb 2. anymore suggestions?

[xtopolis]

SELECT * FROM test 
    WHERE DATE(DATE_ADD(CURDATE(), INTERVAL 1 DAY)) BETWEEN DATE(start) AND DATE(end)
    AND eventtype = 'music'
    ORDER BY start DESC

Theoretically this should pull up any events that are still going on / or starting as of tomorrow.  I haven't tested this.  Also, I'm fairly certain adding the DATE() function around the columns and current date is redundant, but perhaps it's necessary to pull the whole day as you said.

 

If that doesn't work, let us know, and be more specific with what results you want to get back.

[dadamssg]

well done xtopolis! thank you, finally works!