include "db.inc";
$list=array();
$q="SELECT pin,inhalt,text,name,email,datum FROM author";
$r=mysql_query($q,$db);
while($z=mysql_fetch_assoc($r)){
// echo "$z[inhalt] $z[text]\n";
$worte=split("[-\"' ,./?!():]",strtolower(strtr("$z[inhalt] $z[text]",array("{"=>"","}"=>"","["=>"","]"=>"","JUNGLEWORLD:"=>""))));
foreach($worte as $w){
$list[$w][pins][]=$z[pin];
$list[$w][txts][]="$z[inhalt] $z[text] (by $z[name] <". strtr( $z[email], array('@'=>'(ä)','.'=>',') ) ."> on $z[datum])";
}
}
echo "----------
";
ksort($list);
/*
foreach($list as $w=>$link){
echo "
$w | ".count($link)." | ";
foreach($link as $l) echo "[$l]";
echo " |
\n";
}
*/
unset($list['']);
$balt="";
$navi="";
foreach($list as $w=>$link){
if($balt!=substr($w,0,1)){
$b=substr($w,0,1);
$html.="\n";
$navi.="".strtoupper($b)." ";
$balt=$b;
}
$html.= "$w\t".count($link[pins])."\t";
foreach($link[pins] as $i=>$l) $html.= "\n\t[$l] ";
$html.= "
\n";
// flush();
}
echo "$navi
";
echo $html;
?>