I have a table and i want total row of bitwen 2 dates and like colu ‘e ‘and exclude col2 ‘ob_done’ and ‘rebook’

I have a table and i want total row of bitwen
2 dates and like colu ‘e ‘and exclude col2 ‘ob_done’ and ‘rebook’

i try this query but its not working.please help me

SELECT * 
FROM trans   
WHERE collect_date BETWEEN '".$collect_date1."' AND '".$collect_date2."'
  AND col1 LIKE '". 'e' ."%' 
  AND col2 NOT LIKE '". 'job_done'  ."%' 
  AND cal2 NOT LIKE '". 'rebook'  ."%'");