[FX.php List] Query Question

[Derrick Fogle]

query->AddDBParam ('Event_Date', date("n/j/Y", $startDate) . "..." .  
date("n/j/Y", $endDate));


On Sep 7, 2006, at 11:13 AM, Alicia M. Cosenza wrote:

> Hello,
>
> I need to select from my from my database based on a date range
>
> ie. All events between the dates 9/2/2006 to 9/14/2006
>
> I am unsure on how to do this with FX PHP.
>
> I have tried...
>
> $query->AddDBParam ('Event_Date', date("n/j/Y", $startDate), 'gte');
> $query->AddDBParam ('Event_Date', date("n/j/Y", $endDate), 'lte');
>
> but it is not returning all the events in between.  I read something
> earlier about using the '...' between two dates finds all the dates in
> that range but I do not know how to format it to work with AddDBParam.
>
> Thanks for any help,
>
> Alicia Cosenza
>
> PS. Yes, I'm new to FX.php.
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list


Derrick Fogle
derrick at fogles.net