ajay1375
Last Activity:
Apr 13, 2010
Joined:
Apr 13, 2010
Messages:
1
Likes Received:
0
Best Answers:
0
Trophy Points:
0

ajay1375

Peon

Last seen:
Apr 13, 2010
    1. ajay1375
      ajay1375
      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++;
      }
      }
      ?>
  • Loading...
  • Loading...
  • Loading...
  • Loading...
  • Loading...