<form action="suchen.php" method="post">
<input type="text" name="klammid">
<input type="submit" name="ok" value="ok">
</form>

<?

  //datenbak Verbindung
  mysql_connect("localhost", "web82","huebner");
  mysql_select_db("usr_web82_2");
  
  
  //Positiv und Negativ Liste
  if ($klammid != "")
  	{
	
	echo "

";
	echo "<font color=\"green\">";
	
	mysql_query("SELECT * FROM bewertungen WHERE pn='Positiv' and klammid='$_POST[klammid]' and ok='1'");
	echo "<a href=\"suchen2.php?site=positiv\">";
    printf ("Positive Bewertungen: %d\n", mysql_affected_rows());
	echo "</a>";
	
	echo "</font>";
	echo "
";
	echo "<font color=\"red\">";
	
	mysql_query("SELECT * FROM bewertungen WHERE pn='Negativ' and klammid='$_POST[klammid]' and ok='1'");
	echo "<a href=\"suchen.php?site=negativ">";
    printf ("Negative Bewertungen: %d\n", mysql_affected_rows());
	echo "</a>";
	
	echo "</font>";
	echo "

";
	
	}
	
	switch ($site)
	{
	case "positiv" :
	
	$abfragep = "SELECT * FROM bewertungen WHERE klammid='$_POST[klammid]' AND ok='1' and pn='Positiv'";
    $ergebnisp = mysql_query($abfragep);
	
	while($rowp = mysql_fetch_object($ergebnisp))
    {
	echo "<table border=\"1\"><tr><td width=\"90\">";
	echo "Bei Seite: ";
	echo "</td><td width=\"250\">";
	echo "$rowp->page";
	echo "</td></tr><tr><td width=\"90\">";
	echo "Bewertung: ";
	echo "</td><td width=\"250\">";
	echo "$rowp->bewertung";
	echo "</td></tr><tr><td width=\"90\">";
	echo "Nachweis: ";
	echo "</td><td width=\"250\">";
	echo "$rowp->screen";
	echo "</td></tr></table>";
	echo "

";
    }
	
break;
	
	case "negativ":
	
	$abfragen = "SELECT * FROM bewertungen WHERE   klammid='$_POST[klammid]' AND ok='1' and pn='Negativ'";
    $ergebnisn = mysql_query($abfragen);
	
	while($rown = mysql_fetch_object($ergebnisn))
         {
	echo "<table border=\"1\"><tr><td width=\"90\">";
	echo "Bei Seite: ";
	echo "</td><td width=\"250\">";
	echo "$rown->page";
	echo "</td></tr><tr><td width=\"90\">";
	echo "Bewertung: ";
	echo "</td><td width=\"250\">";
	echo "$rown->bewertung";
	echo "</td></tr><tr><td width=\"90\">";
	echo "Nachweis: ";
	echo "</td><td width=\"250\">";
	echo "$rown->screen";
	echo "</td></tr></table>";
	echo "

";
         }
	
	}


?>

$sql = 
    "SELECT 
        id 
    FROM 
        bewertungen 
    WHERE 
        pn='Positiv' AND klammid='$_POST['klammid']' AND ok='1'
    "; 
$qry = mysql_query($sql) or die(mysql_error());
$num = mysql_num_rows($qry);
    echo $num .' positive Bewertungen';