Habe es nun auich so hinbekommen
...
Das Freigeben Klappt! Nur das löschen nicht -.-
Kann es sein, dass der Deletebefehl für MySQL die falsche Syntax hat?
PHP-Code:
<?php
require("config.inc.php");
require("login.inc.php");
require("kopf.php");
require("adminkopf.inc.php");
require("function.inc.php");
if(isset($_POST['freigabe'])){
$komid = $_POST[id];
$newsid = $_POST[newsid];
mysql_query("UPDATE $tab_newskom SET freigabe = '1' WHERE id = '$komid' AND newsid = '$newsid' LIMIT 1;", $serverid);
}
if(isset($_POST['delete'])){
$komid = $_POST[id];
$newsid = $_POST[newsid];
mysql_query("DELETE $tab_newskom WHERE id = '$komid' AND newsid = '$newsid' LIMIT 1;", $serverid);
}
echo "<table border=0 cellspacing=1 cellpadding=3 width=\"100%\">";
echo "<tr><th class=head colspan=3 bgcolor=$c_header>$f_titel Kommentare zur News</th></tr>";
$ergebnis = mysql_query("Select * FROM $tab_newskom ORDER BY time DESC", $serverid);
while ( $kom = mysql_fetch_array ($ergebnis) ) {
if($kom[freigabe] == 0){
echo "<tr>";
//Autor:
echo "<form method=\"post\" action=$PHP_SELF name=\"$kom[id].$kom[newsid]\">";
echo "<input type=\"hidden\" name=\"id\" value=\"$kom[id]\">";
echo "<input type=\"hidden\" name=\"newsid\" value=\"$kom[newsid]\">";
echo "<td valign=top class=\"left\" bgcolor=\"$c_left\"><table $glowstyle><tr><td>$f_author<nobr>";
echo formatkom($kom[author]);
echo "</nobr></tr></td></table><nobr><font size=1>";
echo date("d.m.Y, H:i",$kom[time]+$time_offset);
echo "</nobr></td>";
//Kommentar:
echo "<td class=\"right\" width=\"100%\" bgcolor=$c_right>$f_news";
echo formatkom($kom[text]);
echo "</td>";
echo "<td class=\"right\"bgcolor=$c_right>";
echo "NewsID: $kom[newsid] <br> KomID: $kom[id]";
echo "</td>";
echo "<td class=\"left\" bgcolror=$c_right align=\"right\">";
echo "<input type=\"submit\" name=\"freigabe\" value=\"Freigeben\">";
echo "</td>";
echo "<td class=\"left\" bgcolror=$c_right align=\"right\">";
echo "<input type=\"submit\" name=\"delete\" value=\"Löschen\">";
echo "</td>";
echo "</tr>";
echo "</form>";
}
}
echo "</table>";
?>