Posted by Ewoud Dronkert on 06/05/05 14:29

On Sun, 05 Jun 2005 04:11:25 -0700, Chris wrote:
> So a question becomes, IF jul (is selected in the query for the month
> of July) THEN return any data for junjul AND julaug if they were used
> on the input form and have that data returned under a July query.
>
> Any thoughts?

Assuming you will sensibly have 2 date fields in your table:

$month = 7; // July
$sql = "SELECT id FROM planning WHERE MONTH(startdate)=$month OR
MONTH(enddate)=$month";


--
Firefox Web Browser - Rediscover the web - http://getffox.com/
Thunderbird E-mail and Newsgroups - http://gettbird.com/

[Back to original message]