$zxvf = "../";
$module = "";
$sagmenu = "1";
$title = "Treading Area - Home Page";
include "../header.php";
?>
$SubCatQuery = mysql_query("select SubId, CatId, SubCatName from subcategories order by CatId, SubCatName");
$SubCatCount = mysql_num_rows($SubCatQuery);
$SubId = Array();
$SubCatId = Array();
$SubCatName = Array();
for ($Si=0; $Si < $SubCatCount; $Si++) {
$S = mysql_fetch_array($SubCatQuery);
$SubId[$Si] = $S['SubId'];
$SubCatName[$Si] = $S['SubCatName'];
$SubCatId[$Si] = $S['CatId'];
}
?>
$y = "0";
$CategoryQuery = mysql_query("select CatId, CatName from categories group by CatName order by CatName");
$CategoryCount = mysql_num_rows($CategoryQuery);
for ($Ci=0; $Ci < $CategoryCount; $Ci++) {
if ($y == "0") { echo "\n"; }
echo "";
$Cat = mysql_fetch_array($CategoryQuery);
//if ($cat_value == $Cat['CatId']) { $CatSelect = " selected"; } else { $CatSelect = ""; }
echo "".$Cat['CatName']." \n";
$z = 0;
$zsay = 4; /*
for ($Sa=0; $Sa < $SubCatCount; $Sa++) {
if ($SubCatId[$Sa] == $Cat['CatId']) {
$z = $z + 1;
if ($z==$zsay+1) { break; }
// if ($z == 1) { echo " "; }
echo $SubCatName[$Sa];
if (($z != 1) AND ($z != $zsay)) { echo ", "; }
if ($z == $zsay) { echo "..."; }
}
} */
echo " | ";
if ($y == "1") { echo " \n"; $y=0; } else { $y = $y + 1; }
}
?>
|
$UrunSql = mysql_query(
"select u.*, m.id as MemberId, m.company, c.CountryName
from urun u, subcategories s, members m, country c
where u.sektor = s.SubId and m.id = u.fid
and c.CountryId = m.country
order by RAND()
limit 3
");
?>
for ($i=0; $i
Sell
|
if (is_file($zxvf.$Urun['resim1'])) {
resim($mypath.$Urun['resim1'], 78, 45) ;
} else {
echo " \n";
}
?>
|
Company:
  |
|
}
?>
include "../footer.php";
?>