|
|
require ("database/dbopen.php3");
$cols = 3;
$select = 'SELECT id
, titel
, bild
, verzeichnis
, metagal
FROM galerien
WHERE metagal IS NOT NULL
ORDER BY ord';
$galerien = MySQL($dbName,$select);
$galCnt = MySQL_NUMROWS($galerien);
$rows = ceil(($galCnt)/$cols);
$cnt = ($cols*$rows);
$width = 100/$cols;
$i=0;
while ($i < $cnt){
$id = MySQL_RESULT($galerien,$i,'id');
$titel = MySQL_RESULT($galerien,$i,'titel');
$bild = MySQL_RESULT($galerien,$i,'bild');
$verzeichnis = MySQL_RESULT($galerien,$i,'verzeichnis');
$metagal = MySQL_RESULT($galerien,$i,'metagal');
if ($i/$cols == round($i/$cols) ){
if($i>0){
echo "";
}
echo "";
}
if ($id>0){
echo "| ";
echo " ";
echo "";
echo "";
echo $titel;
echo "";
echo "";
echo " ";
echo "";
echo "";
echo " ";/*width='150' height='150' */
echo "";
echo " ";
echo " | ";
}
else {
echo " | ";
}
$i++;
}
echo " ";
?>
|