connect();
$id=$HTTP_GET_VARS["id"];
if ($id>0)
{
$query = "select texte_id,texte_datum,texte_titel,texte_einleitung";
$query .= ",texte_text,texte_autor";
$query .= ",texte_gruppen_id,texte_ort_id,gruppen.gruppen_name,orte.orte_name";
$query .= ",texte_url,texte_url_flag,texte_ruecktext_flag";
$query .= " from texte";
$query .= " left outer join gruppen on (texte_gruppen_id=gruppen.gruppen_id) ";
$query .= " left outer join orte on (texte_ort_id=orte.orte_id) ";
$query .= " where texte_id=".$id;
//echo $query ;
$ret=$db->query($query,"Fehler!");
}
?>
Plotter - Text
0)
{
while($row=$db->fetch_row($ret))
{
$texte_id=$row[0];
$texte_datum=$row[1];
$texte_titel=$row[2];
$texte_einleitung=$row[3];
$texte_text=$row[4];
$texte_autor=$row[5];
$termine_gruppen_id=$row[6];
$texte_ort_id=$row[7];
$gruppen_name=$row[8];
$ort_name=$row[9];
$texte_url=$row[10];
$texte_url_flag=$row[11];
//echo "hallo:".$texte_datum;
if ($texte_datum>"2006-02-28")
{
$texte_einleitung=strip_tags($texte_einleitung);
//replace carriage returns & line feeds
$texte_einleitung = str_replace(chr(10), "
", $texte_einleitung);
$texte_einleitung = str_replace(chr(13), " ", $texte_einleitung);
$texte_einleitung = makeClickableLinks($texte_einleitung);
$texte_text=strip_tags($texte_text);
//replace carriage returns & line feeds
$texte_text = str_replace(chr(10), "
", $texte_text);
$texte_text = str_replace(chr(13), " ", $texte_text);
$texte_text = makeClickableLinks($texte_text);
}
$datum=substr($texte_datum,8,2).".".substr($texte_datum,5,2).".".substr($texte_datum,0,4);
echo "\n";
echo " \n";
echo " | | \n";
echo "
| \n";
echo " | \n";
echo "
\n";
echo " \n";
echo " | | \n";
echo "
\n";
echo " | \n";
echo " | \n";
echo "
\n";
echo " \n";
echo " | | \n";
echo " | \n";
echo " | \n";
echo "
\n";
echo " \n";
echo " | | \n";
echo " Autor: ".$texte_autor."
| \n";
echo " | \n";
echo "
\n";
echo "
\n";
}
}
?>
Fenster schliessen