Re: Selecting Date Range

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux