search date

Expand Post »

I have dates stored for logs which has three fields February 8 2008 for example.
How can i do a MYSQL querry which selects the logs between march 1 2005 to december 1 2007 for example.
Thanks

Similar Threads

updating 2 HTML tables on one PHP page in PHP
date format problem with access and visual basic in Windows NT / 2000 / XP
"Home Search 'Assistent'"... yet again in Viruses, Spyware and other Nasties
Removal of Home Search Assistent in Viruses, Spyware and other Nasties
Search Results for poker online in Viruses, Spyware and other Nasties

BillyMako

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

16 posts
since Jan 2008

Permalink

Feb 25th, 2008

Re: search date

php Syntax (Toggle Plain Text)

$query="select * from table where date_column between date1 and date2";

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: problem of rhyme game

Next Thread in PHP Forum Timeline: problem in deleting

DaniWeb Message

Cancel Changes

User Name
Password