[FX.php List] Date range and MySQL

Tim 'Webko' Booth tim at nicheit.com.au
Wed Jan 23 20:59:17 MST 2008


> 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]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20080124/6c968566/attachment.html


More information about the FX.php_List mailing list