Use the BETWEEN in your condition as: [code] $conditions = array($yourDate in dateformat.' BETWEEN Model.checkin AND Model.checkout'); [/code]
Enjoy, John On Jan 11, 6:06 pm, sixthpoint <[email protected]> wrote: > I have been scratching my head on how to do this for a few days now. > Lets say the user enters a date in a form and submits it.. the date is > 10/2/10 for example. The database is setup to have a 'checkin' and > 'checkout' date fields already assigned. In those fields for example > we have records like ('10/1/10', '10/10/10') and ('9/30/10', > '10/5/10'). My question is how would I write a query to return the > count of how many times my users input date is between the 'checkin' > date and 'checkout' date in the database? > > I know cake has a between condition for queries, but I am not sure how > to apply it to this problem. > > thanks
Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
