[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