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 easi
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 j
[snip]
Can it be done with just a simple MySQL query ?
[/snip]
Yes.
WHERE `date` BETWEEN `startDate` AND `endDate`
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Wed, 3 Nov 2004 13:47:38 -0500, ConbuD <[EMAIL PROTECTED]> 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.
> I am trying to select a date range in this format from a database 1-Mar-03
> to 26-Mar-03. The date is stored in a mySQL database in that format and
when
> doing a normal select it just selects the dates as if they are numbers.
>
> How can I make this select work the way I want it to work? I am u
5 matches
Mail list logo
