Query won't run using mysql between clause

[eluser]WanWizard[/eluser]
'%%' is interpreted as the literal %, and I assume there is nothing between % and %.

I suggest you change it to

Code:

if ( ! empty($start_date) && ! empty($end_date) )
{
    $dateRange = "tdate BETWEEN '%$start_date%' and '%$end_date%'";
    $this->db->where($dateRange, NULL);
}