CoW

function getList()
{
// ORIGNIALE ---|> $query="SELECT * FROM tradetemp pr, tradetype pa WHERE pr.IDtradertype = pa.IDtradertype";
  $query="SELECT * FROM tradetemp pr, tradetype pa WHERE pr.IDtradertype = pa.IDtradertype";
  // Here we check if we have a query parameter :
  if (isset($_POST['query'])){
                $query .= " AND (pr.domaine LIKE '%".$_POST['query']."%' OR pr.url LIKE '%".$_POST['query']."%')";
  }
  //echo $query;
  $result = mysql_query($query);




  $nbrows = mysql_num_rows($result);
  $start = (integer) (isset($_POST['start']) ? $_POST['start'] : $_GET['start']);
  $end = (integer) (isset($_POST['limit']) ? $_POST['limit'] : $_GET['limit']);
  $limit = $query." LIMIT ".$start.",".$end;
  $result = mysql_query($limit);
  
  if($nbrows>0){
    while($rec = mysql_fetch_array($result)){
            // render the right date format
      $rec['inscription']=codeDate($rec['inscription']);
      $rec['banni']=codeDate($rec['banni']);
      $arr[] = $rec;
    }
    $jsonresult = JEncode($arr);
    echo '({"total":"'.$nbrows.'","results":'.$jsonresult.'})';
  } else {
    echo '({"total":"0", "results":""})';
  }
}