Matching dates?

[JF1980]

I am having a spot of trouble in my logic and was wondering if anyone can help. Im sure there is such an easy way to do what I want but I am missing that tiny bit of knowledge.

I am writing a page to display a log of the events which happened in the last month, or it would be better to display the events from the last x weeks (with x being user selectable).

The evens are stored in a mySQL DB. The time of the event is called incident_time and is in the format YYYY-MM-DD HH:MM:SS

How can I make this query work, when I started with this idea I had it so simply in my mind, and to do manually it is so easy, but converting that logic into an SQL query is proving a challenge.

Any ideas?

[jburfield]

Not sure if this is what you are after, but you could do something like this:

$user_date = "2002-01-01"
This is the day the person wants to see information for.

In your query, just search for everything with a substring statement...

$query = "SELECT * from YOUR_TABLE where substring(YOUR_DATE_FIELD, 1, 10) = "$user_date"

That would give you everything for that one individual day...you can mess with this and add multiple dates, etc.

-- Jason

[the_Igel]

There are mySql functions DATE_ADD() and DATE_SUB() . Look for them in the mySQL manual and the problem is nearly solved.

http://www.mysql.com/doc/en/Date_and_time_functions.html