SELECT count(*) FROM tb_Deficiency WHERE tb_Deficiency.col_CompletedDate <= CURDATE() AND tb_Deficiency.col_CompletedDate >= (CURDATE() - INTERVAL 7 DAY) AND tb_Deficiency.col_Centre LIKE '$var_Centre'