BUYING LEADS
COUNTRY :"; $sql = mysql_query("SELECT CountryId as id, CountryName as ulke FROM country ORDER BY ulke ASC"); if ($_GET['ulke'] == "") { $ulke_select = " selected"; } else if ($_GET['ulke'] == 0) { $ulke_selected = " selected"; } else { $ulke_selected = ""; } echo "All COUNTRIES\n"; for ($u=0; $u".$ulke['ulke']."\n"; } echo ""; echo "  CATEGORY : "; $sql = "select CatId as id, CatName as anasektor from categories order by anasektor asc"; $sorgu = mysql_query($sql); if ($_GET['sektor'] == "") { $sektor_select = " selected"; } else if ($_GET['sektor'] == 0) { $sektor_selected = " selected"; } else { $sektor_selected = ""; } echo "All CATEGORIES\n"; for ($i=0; $i".$x['anasektor']."\n"; } echo "
SHOW 25 50 75 100  RECORDS/PAGE   SORT BY : Date Category Country Subject SORT TYPE : Decending [Z-A 9-0] Ascending [0-9 A-Z] "; 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"; ?>