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. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.784 / Virus Database: 530 - Release Date: 10/27/2004 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php