Re: Selecting Date Range

On Wednesday 03 November 2004 18:47, 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. If you're not storing your dates as a real date/time column but as simple varchar column then you've created unnecessary work for yourself. I strongly suggest that you use proper date column types and then you can take advantage of the date handling functions available in MySQL. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general ------------------------------------------ /* A beer delayed is a beer denied. */