ok
this is the supposed to be query of mine
$dataProvider = new CActiveDataProvider('Wsrecruitcvhead',array(
'criteria' => array(
'select' => 'ResumeID, ResumeTitle, ResumeSummaryIntroduction',
'addSearchCondition' => array('ResumeTitle', $resumetitle),
'addSearchCondition' => array('ResumeSummaryIntroduction', $resumesummaryintroduction),
'addSearchCondition' => array('SummaryOfSkills', $summaryofskills),
'with' => array(
'wsrecruittimes' => array(
'on' => 'wsrecruittimes.ResumeID=wsrecruitcvhead.ResumeID',
'joinType' => 'INNER JOIN',
'addSearchCondition' => array('AvailableToWorkSunday', $sun),
'addSearchCondition' => array('AvailableToWorkMonday', $mon),
'addSearchCondition' => array('AvailableToWorkTuesday', $tue),
'addSearchCondition' => array('AvailableToWorkWednesday', $wed),
'addSearchCondition' => array('AvailableToWorkThursday', $thurs),
'addSearchCondition' => array('AvailableToWorkFriday', $fri),
'addSearchCondition' => array('AvailableToWorkSaturday', $sat),
'addBetweenCondition' => array('DateCreated',DATE_ADD(NOW(),INTERVAL -1 DAY),NOW(),'AND'),
)
),
),
));
any ideas how to fix that ?, am referring to the addBetweenCondition at the bottom of the code above
if am gonna use php functions, as what blindmoe said, do you have any suggestion how to insert or what to do ?