Mysql Results for > 2 Days Ago

[Guest]

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 solution]

.oO(sfopp)

> 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()?

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-add

Micha

[Guest]

Thanks Micha!

That was exactly what I needed!

[Newsgroup_User]

.oO(sfopp)

>Thanks Micha!
>
>That was exactly what I needed!

You're welcome.

Micha