Re: array + sql problem

2010-01-31 Thread newbie
got it before it was acked start with is not for that :/ i should have add % mark at the end of searched date $creaded [10]=% and use LIKE, WHERE Audit.created LIKE $creaded Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You

array + sql problem

2010-01-30 Thread newbie
hi All, I've got a problem of how statment in array is translated into sql Below is my function that is supposed to find records od certain day. field creaded is day+hour dormat -mm-dd 00:00:00; in variable $created there's only -mm-dd. I would like to find all records that start with $cr