Mysql Results for 2 Days Ago

Question

Hi All,

I am making a site for a band and would like to have a
section of the site that shows when their performances will be. I'd
like this to show all upcoming events plus any events that have
happened within the last 2 days.

Right now I have my mysql query set up with "WHERE
Shows.show_date >= NOW()" and that works OK but is there a way
to also pull the data for events from 2 days prior to NOW()?

I'm using mysql and php.

Thanks in advance for any help/suggestions you might
have!

Newsgroup_User · Accepted Answer

.oO(sfopp)> I am making a site for a band and would like to have asection of the site >that shows when their performances will be. I'd like thisto show all upcoming >events plus any events that have happened within the last2 days.>> Right now I have my mysql query set up with "WHEREShows.show_date >= NOW()" >and that works OK but is there a way to also pull thedata for events from 2 >days prior to NOW()?Sure. Have a look at DATE_SUB()/DATE_ADD():http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-addMicha

Newsgroup_User · Answer

.oO(sfopp)>Thanks Micha!>>That was exactly what I needed!You're welcome.Micha

Mysql Results for > 2 Days Ago

3 replies

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded