$sql=mysql_query("SELECT * FROM `expense` WHERE `date` BETWEEN '2011-04-26' AND '2011-04-28'") or die(mysql_error());
//SELECT * ... assuming that the * includes some field named `id`, then the following
//will print it's contents:
//if you want to see everything at once, use:
iwant to to knwn that if a student has not paid fee on the month and next month he pay how would a query will be used to double his fee becuase he has not pay for previous month also..should i use while loop...