[FX.php List] Date range and MySQL
Chris Hansen
chris at iViking.org
Thu Jan 24 01:36:04 MST 2008
Dale,
Although it's not the more common AddDBParam() method, there are times
when it makes the most sense to use PerformSQLQuery(). This replaces
both the parameters and the action call. Check it out and let me know
if you have any questions. HTH
--Chris
On Jan 23, 2008, at 8:50 PM, Dale Bengston wrote:
> Hi folks,
>
> Anyone know what the parameter should look like to do a date range
> search with FX to MySQL?
>
> In FMP, it would look like this:
>
> $findRec->AddDBParam('myDate', $startDate . '...' . $endDate);
>
> How would this translate to MySQL?
>
> Thanks,
> Dale
>
>
>
>
> --
> Dale Bengston
> Partner, The Whole Brain Group, LLC
> TheWholeBrainGroup.com
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
More information about the FX.php_List
mailing list