mysql_query("SELECT campo1,campo2 FROM tabla WHERE fecha BETWEEN '2005-12-10' AND '2006-01-06' ") or die(mysql_error());