Re: Selecting Date Range
| From: | John Nichel | Date: | Wed, 03 Nov 2004 19:06:37 +0000 |
| Subject: | Re: Selecting Date Range | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-201074@lists.php.net to get a copy of this message | ||
ConbuD wrote:
Hey, I have a database with approx 200-300 students in it. I wanna be able to pull out what student joined a class with in a certain date range. Say I wanna get all the students who joined between 10/12/04 through 12/12/04. What is the easiest way to do this ? Can it be done with just a simple MySQL query ? I actually enter the date as shown above, I dont use the MySQL dates. Any help will be greatly appreciated.Look at BETWEEN in MySQL. http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 john@kegworks.com