aviatorisu Posted September 2, 2006 Share Posted September 2, 2006 Anyone out there got something like this? I want a script to recognize the Month and day and then compare it against database entries for events that happened on the same date through history. I'm not very good when it comes to the whole "date" thing or I could probably get it myself. Any help would be appreciated.Thx,~Z~ Quote Link to comment Share on other sites More sharing options...
tomfmason Posted September 2, 2006 Share Posted September 2, 2006 that is a realy rather simple. I think that you are trying to over think this one. I often do this my self. Are you wanting to search by month or day or both? Quote Link to comment Share on other sites More sharing options...
aviatorisu Posted September 2, 2006 Author Share Posted September 2, 2006 Not even a search. Just something to display in a small box on the front page of my site. Something like this:[img]http://www.lasvegas247.net/date.jpg[/img]I think it always helps me if I can just see an example. Lots of things I can work out for myself if I just sit down long enough, but like I said, the whole date format thing screws me up.~Z~ Quote Link to comment Share on other sites More sharing options...
Barand Posted September 2, 2006 Share Posted September 2, 2006 SELECT whatever, (YEAR(CURDATE())-YEAR(event_date)) as years_ago FROM event_tableWHERE MONTH(event_date) = MONTH(CURDATE())AND DAY(event_date) = DAY(CURDATE()) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.