Selecting values between two dates

[dougmcc1]

I have thousands of records in my database from the past year. Is there a way I can "SELECT field WHERE date IS BETWEEN $firstdate AND $seconddate" or similar?

Thanks.

[devinemke]

you basically answered your own question.

SELECT * FROM table WHERE date BETWEEN '$firstdate' AND '$seconddate'

[dougmcc1]

How do I count the number of times each vaue gets returned? I'm only selecting one value.

[devinemke]

Originally posted by dougmcc1
How do I count the number of times each vaue gets returned?

SELECT COUNT(*) FROM table WHERE date BETWEEN '$firstdate' AND '$seconddate'

[dougmcc1]

Sorry I should've given you more info. I'm running that first query to find "value" between two dates. Now I need to count the number of times each value gets returned and output it like this:

value (number of times it exists in the date range)
value 2 (number of times it exists in the data range)
etc.

So this is different than just counting the total number of values within the date range.

Actually, I just got it. Thanks for your help.

[paulnaj]

Show us it, then :queasy:

P.

[dougmcc1]

SELECT COUNT(value) FROM table WHERE (date BETWEEN '$firstdate' AND '$seconddate') AND value='$value'