if(!empty($arrq))
{
foreach($arrq as $val)
{
$sql=”select * from user where sponsor=”.$val;
$rs=mysql_query($sql);
while($row=mysql_fetch_array($rs))
{
$arrq2[]=$row[‘dmecode’];
$arr_dataq2[]=”<tr align=’center’ class=’normal’><td></td><td>”.$row[‘dmecode’].”</td><td>”.$row[‘fname’].”</td><td>”.$val.”</td><td>”.$row[‘placement_type’].”</td></tr>”;
}
$date=date(“Y-m-01”,time()) ;
$tomorrow=date(“Y-m-31″,time());
$sql3=”select count(*) from user where sponsor=”.$val.” AND `date` BETWEEN ‘$date’ AND ‘$tomorrow'”;
$rs3=mysql_query($sql3)or die(“Error in query-251”);
$l3count=0;
while($row=mysql_fetch_array($rs3))
{
$l3count=$l3count+1;
$date3=$row[‘date’];
}
}
}
?>
<?
if(!empty($arr1r))
{
foreach($arr1r as $valr)
{
$date=date(“Y-m-01”,time()) ;
$tomorrow=date(“Y-m-31″,time());
$sqlr=”select * from user where sponsor=”.$valr;
$rsr=mysql_query($sqlr);
while($row1r=mysql_fetch_array($rsr))
{
$arr2r[]=$row1r[‘dmecode’];
$arr_data2r[]=”<tr align=’center’ class=’normal’><td></td><td>”.$row1r[‘dmecode’].”</td><td>”.$row1r[‘fname’].”</td><td>”.$valr.”</td><td>”.$row1r[‘placement_type’].”</td></tr>”;
}
//count r3
$date=date(“Y-m-01”,time()) ;
$tomorrow=date(“Y-m-31″,time());
$sqlr=”select count(*) from user where sponsor=”.$valr.” AND `date` BETWEEN ‘$date’ AND ‘$tomorrow'”;
$rsr=mysql_query($sqlr);
$r3count=0;
while($row1=mysql_fetch_array($rsr))
{
$r3count=$r3count+1;
$date3r=$row1r[‘date’];
}
}
}
?>
<?
$d3l=$date3l;
$d3r=$date3r;
$l3=$l3count;
$r3=$r3count;
$l3count=$l3count;
echo “<tr align=’center’ class=’normal’><td> “.$d3r.” </td><td> 3</td><td> “.$l3.” </td><td> “.$r3.” </td><td><input type=’text’ name=’text3′ id=’text3′ onblur=’addition()’ value=”.$l3count.” ></td>”;
?>
