SELECT dateofbooking, count(id) AS total FROM participant WHERE dateofbooking >= $datepick AND
  dateofbooking <= DATE_ADD($datepick, INTERVAL 5 DAY)GROUP BY dateofbooking;