$module = "offers";
$sagmenu = "1";
$title = "Treading Area - Offers";
include "../header.php";
$module = $_GET['module'];
$submodule = $_GET['submodule'];
if ($_GET['max'] == "") { $max = 25; } else { $max = $_GET['max']; }
$page = $_GET['page'];
if (!isset($page)) $page=1;
if ($page=="") $page=1;
$alt=($page - 1) * $max;
echo "
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 " ".number_format($s1)." buying leads found on system. |
";
$ss=$s1/$max;
$ss=ceil($ss);
if ($ss>1) {
echo " Pages : |
";
echo "";?>
Business Category |
Date |
Country |
Subject |
Details |
for ($i=0; $i
".$x['anasektor']." |
".$tarih." |
".$x['Ulke']." |
".$x['Konu']." |
Details |
\n";
}
echo "
";
include "../footer.php";
?>