 |
| |
|
| |
ΚΑΤΗΓΟΡΙΕΣ
CATEGORIES
|
| |
|
execute("$q");
$n=$rs->RecordCount();
//echo '->' . $n . '';
if ($n>0) {
for ($i=0;$i<$n;$i++) {
if ($cat_id==$rs->fields['cat_id'])
$sel='_sel';
else $sel='';
if ($_REQUEST['tsel']!=null)
$tsel=$_REQUEST['tsel'];
?>
| |
|
|
fields['cat_id']) {
?>
| |
fields['cat_name'].' :: '.printDataset($lang,'subcategories', null, '*', 'sca_order', 'sca_name', 'sca_id', $rs->fields['cat_id'], 'cat_id', $sca_id, null, 'class=subcategory', 'category.php', ' where cat_id=' . $rs->fields['cat_id']);
else
$tsel=$rs->fields['cat_name_en'].' :: '.printDataset($lang,'subcategories', null, '*', 'sca_order', 'sca_name_en', 'sca_id', $rs->fields['cat_id'], 'cat_id', $sca_id, null, 'class=subcategory', 'category.php', ' where cat_id=' . $rs->fields['cat_id']);
if (substr(trim($tsel),strlen(trim($tsel))-2,2)=='::')
$tsel = substr(trim($tsel),0,strlen(trim($tsel))-2);
?>
|
MoveNext();
}
}
?>
| |
|
|
 |
|
execute("$q");
$n=$rs->RecordCount();
$col=0;
if (($n==0) && ($sca_id==null)) { // no products, yes subcategories
print '
' . $tsel . '
';
$q="select * from categories where cat_id=".$cat_id;
$rs = $DB->execute("$q");
if (strtoupper($lang)=='GR')
$catDescr=$rc->fields["cat_descr"];
else
$catDescr=$rc->fields["cat_descr_en"];
if ($catDescr!=null)
print '
' . $catDescr . '
';
$q="select * from subcategories where cat_id=".$cat_id . ' order by sca_order';
$rs = $DB->execute("$q");
$n=$rs->RecordCount();
if ($n==0) { // no products, no subcategories
$q="select * from categories where cat_id=".$cat_id;
$rs = $DB->execute("$q");
if ($rs->fields['photo_id_1']!=null) {
$obj = new lookupText('photos', 'photo_id', $rs->fields['photo_id_1'], 'photo_path', '', '');
$photoPath=$obj->getHtml();
} else $photoPath='images/noimg.jpg';
?>
fields["cat_descr"];
else
$catDescr=$rc->fields["cat_descr_en"];
print '
' . $catDescr . '
';
?>![]() |
fields['photo_id'], 'photo_path', '', '');
$photoPath=$obj->getHtml();
?>
MoveNext();
}
}
?>
|
';
print '' . $tsel . '
';
$q="select * from categories where cat_id=".$cat_id;
$r = $DB->execute("$q");
if (strtoupper($lang)=='GR') {
if ($rs->fields['cat_descr']!=null) print $rs->fields['cat_descr'] . '
';
} else {
if ($rs->fields['cat_descr_en']!=null) print $rs->fields['cat_descr_en'] . '
';
}
for ($i=0;$i<$n;$i++) {
if ($rs->fields['photo_id']!=null) {
$obj = new lookupText('photos', 'photo_id', $rs->fields['photo_id'], 'photo_path', '', '');
$photoPath=$obj->getHtml();
} else $photoPath='images/noimg_100.jpg';
if (($photoPath!=null) && ($photoPath!='-') && ($photoPath!='')) {
list($width, $height) = getimagesize("$photoPath");
if ($height>85) {
$newheight=85;
$percent=$newheight/$height;
$newwidth = $width * $percent;
$height=85;
if ($newwidth<=85)
$lwidth=85;
else
$lwidth=$newwidth;
$width=$newwidth;
?>
MoveNext();
}
if ($n>36) {
?>
|
|