Index
$sql= "SELECT begriff_ID, begriff, kategorie FROM begriff ORDER BY begriff";
$result = mysql_query($sql,$conn);
$zeile = 0;
echo "
";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$zeile++;
if (is_int($zeile / 2)) {
$tdclass="indextab1";
}
else {
$tdclass="indextab2";
}
echo "$row[kategorie] | ";
echo "$row[begriff] | ";
$sql = "SELECT band, seite, hauptreferenz FROM referenz JOIN indices WHERE indices.begriff_ID = $row[begriff_ID] AND indices.referenz_id = referenz.referenz_ID ORDER BY band, (seite+0)";
$rs = mysql_query($sql,$conn);
$num = mysql_num_rows($rs);
$i = 1;
$voriger_band = "";
while ($refer = mysql_fetch_array($rs, MYSQL_ASSOC)) {
$style = "";
if ($refer[hauptreferenz]) {
$style="hauptindex";
}
if ($refer[band] == $voriger_band) {
echo "$refer[seite]";
}
else {
echo "$refer[band] $refer[seite]";
}
if ( $i != $num) { echo ", "; }
$i++;
$voriger_band= $refer[band];
}
echo " |
\n";
}
echo "
";
?>