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

• Next in forum: How to Replace Backslash ( \ )?
• Prev in forum: Re: Joining many results from one table with one result from another in one query
• Thread view: Getting an MySQL first day and last day statement

[Reply to this message]