Please help me to solve this problem !!! <?php $t=0; if (isset($_POST) || isset($_POST)) { $date1=date('d-m-Y', strtotime($_POST)); $date2=date('d-m-Y', strtotime($_POST)); $sql2 = "select usid,spid from register"; $result2 = mysql_query($sql2,$conn); $total=mysql_fetch_assoc($result2); while ($total<=mysql_fetch_assoc($result2)) { $id=mysql_result($result2,$t,"usid"); $sql = "select level, count(*) from legcount where spid='$id' and jdate >= '$date1' and jdate <= '$date2' group by level having count(level)>0"; $result = mysql_query($sql,$conn) ; $num=mysql_fetch_assoc($result); $i=0;$total=0;$ftotal=0;$ref=0; while ($i <= mysql_fetch_assoc($result)) { $f2=mysql_result($result,$i,"count(*)"); $total=$f2*25; $ftotal=$ftotal+$total; $i++; } $t++; } } ?>