Posted by laredotornado on 02/23/06 19:24

Hi,

On a search form, we are going to have someone pick a month fo the year
for which they'd like to search for trips. Here is an example option
from the menu

<OPTION value="2006-03-01 00:00:00.0">March 2006</OPTION>

How can I write a MySQL statement that asks "give me all trips between
(and including) the first day of March, 2006 and the last day of March,
2006?"

I'm using MySQL 4, PHP 4.

Thanks, - Dave

[Back to original message]