BUYING LEADS
COUNTRY :"; echo "  CATEGORY :
SHOW  RECORDS/PAGE   SORT BY : SORT TYPE : "; if ($_GET['sektor'] <> "") { if ($_GET['sektor'] == "tumu") { $alan_id = ""; } else { $alan_id = " AND talep.SektorKodu = '".$_GET['sektor']."'"; $alanid = $_GET['sektor']; } } else { $alan_id = ""; } if ($_GET['ulke'] <> "") { if ($_GET['ulke'] == "tumu") { $ulkesql = ""; } else if ($_GET['ulke'] == "0") { $ulkesql = ""; } else { $ulkesql = " AND talep.ulkeid = '".$_GET['ulke']."'"; $ulkeid = $_GET['ulke']; } } else { $ulkesql = ""; } $orderby = ""; if ($_GET['sirala'] == "Tarih") { $orderby = " ORDER BY talep.Tarih"; } if ($_GET['sirala'] == "SektorAdi") { $orderby = " ORDER BY categories.CatName"; } if ($_GET['sirala'] == "Ulke") { $orderby = " ORDER BY talep.Ulke"; } if ($_GET['sirala'] == "Konu") { $orderby = " ORDER BY talep.Konu"; } if ($_GET['kriter'] == "ASC") { $kriterby = " ASC"; } if ($_GET['kriter'] == "DESC") { $kriterby = " DESC"; } if ($orderby ==""){ $orderby = "ORDER BY talep.Tarih DESC"; } $q1 = mysql_query("select * from talep, categories, country where talep.ulkeid = country.CountryId and talep.SektorKodu = categories.CatId and talep.TeklifKodu = '2'".$alan_id.$ulkesql.$orderby.""); $s1 = mysql_num_rows($q1); $talepsql = "Select talep.No, talep.Tarih, talep.Ulke, talep.Konu, categories.CatName as anasektor from talep, categories, country where talep.ulkeid = country.CountryId and talep.SektorKodu = categories.CatId and talep.TeklifKodu = '2'".$alan_id.$ulkesql.$orderby.$kriterby." LIMIT $alt, $max"; $sorgu = mysql_query($talepsql); $kayit_sayisi = mysql_num_rows($sorgu); echo "\n"; } echo "
  ".number_format($s1)." buying leads found on system. "; $ss=$s1/$max; $ss=ceil($ss); if ($ss>1) { echo "
Pages :
 ".$x['anasektor']." ".$tarih." ".$x['Ulke']." ".$x['Konu']." Details
"; include "../footer.php"; ?>