$sql = "select * from categories where active = 1 and loc = 1 ";
$result = mysql_query($sql) or die (mysql_error());
$count = 0;
while ($eintrag = mysql_fetch_array($result)) {
$count = $count + 1;
if ($count == $cat) {
echo '
',$eintrag['text_e'],'
';
} else {
echo '
',$eintrag['text_e'],'
';
}
}
echo '
Computer Training
';
$sql = "select * from categories where id = ".$cat." ";
$result = mysql_query($sql) or die (mysql_error());
$eintrag = mysql_fetch_array($result);
$dir = $eintrag['imagepath'];
//determine number of entries in that category
$sql = "select * from samples where category_id = ".$cat." ";
$result = mysql_query($sql) or die (mysql_error());
$num_rows = mysql_num_rows($result);
?>
//determine target id for left arrow
if ($id == 1) {
$prev = $num_rows;
} else {
$prev = $id - '1';
}
if ($id) {
$sql = "select * from samples where id = ".$id." and category_id = ".$cat." ";
$result = mysql_query($sql) or die (mysql_error());
$eintrag = mysql_fetch_array($result);
echo '

';
$zoomwidth = $eintrag['hsize600'];
}
if ($zoomwidth == 0) {$zoomwidth = '600';}
?>
if (is_file("/home/wolfgdbi/www.wolfgangthede.de/images600".$dir.$eintrag['path_e'])) {
$path = 'images600'.$dir.$eintrag['path_d'];
$img = " ";
} else {
if ($eintrag['link_d']) {
$img = " ";
} else {
$img = " ";
}
}
echo $img;
?>
|
//determine target id for right arrow
if ($id == $num_rows) {
$next = 1;
} else {
$next = $id + '1';
}
if ($id) {
echo '

';
}
?>
$theheadline = $eintrag['headline_e'];
$thetext = $eintrag['text_e'];
echo '
',$theheadline,'
';
echo '
',$thetext,'
';
if ($eintrag['link_e']) {
$thelink = "
".Original." ".Page."";
echo '
',$thelink,'
';
}
?>
$count = 0;
while ($count < $num_rows) {
$count = $count + 1;
$sql = "select * from samples where id = ".$count." and category_id = ".$cat." ";
$result = mysql_query($sql) or die (mysql_error());
$eintrag = mysql_fetch_array($result);
$img = "
";
echo $img;
}
?>