help?

[dadamssg]

This query pulls up events that are all happening today, 24hr period. how do i turn this into always pull up tomorrows?

 

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

[Snart]

CURDATE() + 1 should add a day.

[Chicken Little]

Assuming your table has a date field (here called date_created) you can use

 

SELECT * FROM test

WHERE DATE(date_created) >= DATE_ADD( CURDATE( ) , INTERVAL +1

DAY)

ORDER BY date_created DESC

[dadamssg]

what exactly does the curdate() function output? maybe i just play around with the right format ill get somewhere because my table has a created, start, and end fields...so im tryin to select the ones that going on tomorrow according to the start and end fields..if that makes sense...

[Chicken Little]

Ok. If your field is called end you can use

 

SELECT * FROM test

WHERE DATE( end ) = DATE_ADD( CURDATE() , INTERVAL +1

DAY )

ORDER BY end DESC

[dadamssg]

worked perfect thank you...and im gonna create a selection list for the user to select a date and then pull up everything thats goin on on that date...what date format does sql understand? cause i tried (2009-02-02) and (2009-02-02 00:00:00) and although both of those didn't get an error, they didn't select anything...

[dadamssg]

take that back...cause some of my events last for days, say jan 31 to feb 5...and that query won't pull of that event...the query has to be based on the start and end datetime...

[dadamssg]

haha i don't know if im talkin to myself but i modified chicken littles request to below and it works, but i still want to know the format CURDATE() is so i can use that for my date selection list.

 

SELECT * FROM test WHERE DATE(start) <= DATE_ADD( CURDATE(), INTERVAL+1 DAY) AND DATE(end) >= DATE_ADD( CURDATE(), INTERVAL +1 DAY) ORDER BY start DESC	

[fenway]

Then use DATE_FORMAT().

 

And CURDATE()+1 is pure evil, use CURDATE()+INTERVAL 1 DAY.