[FX.php List] Date range and MySQL

[Dale Bengston]

I can sort out the meaning of "between" later. I need the syntax that  
translates an FX AddDBParam to a MySQL date range select.

On Jan 23, 2008, at 10:06 PM, Gjermund Gusland Thorsen wrote:

> What does between mean?
>
> if I but in between March 5 and March 15 will it return
>
> March 5 through March 15
> or will it return
> March 6 through March 14
> the latter would actually be between the two mentioned dates...
>
>
> 2008/1/24, Tim 'Webko' Booth <tim at nicheit.com.au>:
>>
>> In FMP, it would look like this:
>>
>> $findRec->AddDBParam('myDate', $startDate . '...' . $endDate);
>>
>> How would this translate to MySQL?
>>
>> Well, the actual SQL would look like:
>> select *
>> from table
>> where date between [start date] and [end date]
>>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list