$sqlsel=sprintf("SELECT * FROM `clientreport` ");
          $sqlcount=sprintf("select count(*) as noofrecords FROM `clientreport` ");
          $sqlsel .= sprintf("where `createddate` BETWEEN  '%s' AND '%s'  ",$frmdate,$todate) ;
          $sqlcount .=sprintf("where `createddate` BETWEEN '%s' AND '%s' ",$frmdate,$todate) ;

    }
    else
    {
          $sqlsel=sprintf("SELECT * FROM `clientreport` ");
          $sqlcount=sprintf("select count(*) as noofrecords FROM `clientreport` ");
    }
  }
 if($_REQUEST['selData']!="Translation" || $_REQUEST['selData']!="allwork" || $_REQUEST['selData']!="POReport")
 {
  if(!empty($_REQUEST['FrmDate']) && !empty($_REQUEST['ToDate']))
  {
            $frmdt=explode("-",$_REQUEST['FrmDate']);
            $todt=explode("-",$_REQUEST['ToDate']);
            $frmdate=$frmdt[2]."-".$frmdt[1]."-".$frmdt[0];
            $todate=$todt[2]."-".$todt[1]."-".$todt[0];
            if(isset($_REQUEST['selUser'])!='' || isset($_REQUEST['selClient'])!='' || isset($_REQUEST['selCoordintaor'])!='' || isset($_REQUEST['selJobStatus'])!='')
            {
             $sqlsel .= sprintf("  AND `createddate` BETWEEN  '%s' AND '%s'  ",$frmdate,$todate) ;
             $sqlcount .=sprintf("  AND `createddate` BETWEEN '%s' AND '%s' ",$frmdate,$todate) ;
            }
            else
            {
              $sqlsel=sprintf("SELECT * FROM `clientreport` ");
              $sqlcount=sprintf("select count(*) as noofrecords FROM `clientreport` ");
              $sqlsel .= sprintf("where `createddate` BETWEEN  '%s' AND '%s'  ",$frmdate,$todate) ;
              $sqlcount .=sprintf("where `createddate` BETWEEN '%s' AND '%s' ",$frmdate,$todate) ;
            }
  }
 }
  $sqlsel .= sprintf(" ORDER BY `clientreport`.`id` DESC " );
  $sqlcount .= sprintf(" ORDER BY `clientreport`.`id` DESC " );