title: PDO PHP - Find all rows between 2 dates - shows blank
body: <p>Using PDO php i am trying to get all the rows in my database tables that have a start_date within the current week. To calculate the first and last date of this week i use the following:</p>
  
  <pre><code>$week_start = date('d-m-Y',time()+( 1 - date('w'))*24*3600);  
  $week_end =  date('d-m-Y',time()+( 7 - date('w'))*24*3600); 
  </code></pre>
  
  <p>Then within my pdo query i have:</p>
  
  <pre><code>$query = " 
      SELECT 
          *
      FROM 
          bookings as bb 
      INNER JOIN 
          reservation as br ON bb.booking_id=br.bookings_id
      INNER JOIN 
          cars as bc ON br.car_id=bc.car_id 
      WHERE 
          payment_success=1 AND 
          is_block=false AND 
          is_deleted=0 AND
          DATE_FORMAT(start_date, '%d-%m-%Y') 
          BETWEEN '".$week_start."' AND '".$week_end."'
  "; 
  
  try { 
      $stmt = DB::get()-&gt;prepare($query); 
      $stmt-&gt;execute(); 
  
      $rows = $stmt-&gt;fetchAll();
  }  
  catch(PDOException $ex) { 
      die("Failed to run query: " . $ex-&gt;getMessage()); 
  } 
  
  foreach($rows as $row):
      $row['booking_id'] etc...
  endforeach;
  </code></pre>
  
  <p>The problem is i am not getting any rows to show up in the output despite having multiple bookings which have a start date within this week</p>