{"id":66,"date":"2011-07-07T05:17:32","date_gmt":"2011-07-07T05:17:32","guid":{"rendered":"http:\/\/blog.raghwendra.com\/?p=66"},"modified":"2014-02-11T07:43:43","modified_gmt":"2014-02-11T07:43:43","slug":"super-bonanza","status":"publish","type":"post","link":"https:\/\/www.raghwendra.com\/blog\/super-bonanza\/","title":{"rendered":"super bonanza"},"content":{"rendered":"

\"coding\"
\nif(!empty($arrq))
\n{
\nforeach($arrq as $val)
\n{
\n$sql=”select * from user where sponsor=”.$val;
\n$rs=mysql_query($sql);
\nwhile($row=mysql_fetch_array($rs))
\n{<\/p>\n

$arrq2[]=$row[‘dmecode’];<\/p>\n

$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>”;
\n}
\n$date=date(“Y-m-01”,time()) ;
\n$tomorrow=date(“Y-m-31″,time());<\/p>\n

$sql3=”select count(*) from user where sponsor=”.$val.” AND `date` BETWEEN ‘$date’ AND ‘$tomorrow'”;
\n$rs3=mysql_query($sql3)or die(“Error in query-251”);
\n$l3count=0;
\nwhile($row=mysql_fetch_array($rs3))
\n{<\/p>\n

$l3count=$l3count+1;
\n$date3=$row[‘date’];<\/p>\n

}
\n}
\n}<\/p>\n

?><\/p>\n

<?
\nif(!empty($arr1r))
\n{<\/p>\n

foreach($arr1r as $valr)
\n{
\n$date=date(“Y-m-01”,time()) ;
\n$tomorrow=date(“Y-m-31″,time());
\n$sqlr=”select * from user where sponsor=”.$valr;<\/p>\n

$rsr=mysql_query($sqlr);
\nwhile($row1r=mysql_fetch_array($rsr))
\n{
\n$arr2r[]=$row1r[‘dmecode’];<\/p>\n

$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>”;
\n}<\/p>\n

\/\/count r3<\/p>\n

$date=date(“Y-m-01”,time()) ;
\n$tomorrow=date(“Y-m-31″,time());
\n$sqlr=”select count(*) from user where sponsor=”.$valr.” AND `date` BETWEEN ‘$date’ AND ‘$tomorrow'”;
\n$rsr=mysql_query($sqlr);
\n$r3count=0;
\nwhile($row1=mysql_fetch_array($rsr))
\n{
\n$r3count=$r3count+1;
\n$date3r=$row1r[‘date’];<\/p>\n

}
\n}
\n}<\/p>\n

?><\/p>\n

<?<\/p>\n

$d3l=$date3l;
\n$d3r=$date3r;
\n$l3=$l3count;
\n$r3=$r3count;
\n$l3count=$l3count;<\/p>\n

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>”;
\n?><\/p>\n","protected":false},"excerpt":{"rendered":"

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()) ;<\/p>\n","protected":false},"author":8,"featured_media":231,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-66","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-miscellaneous","entry"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t