Manuel: LIMIT $x spuckt eine fehlermeldung aus!

Beitrag lesen

<?

// MUSS AM ANFANG STEHEN! Legt den relativen Pfad zum Stammverzeichnis fest
   $ttl_root = './../';

// MUSS VOR TOP STEHEN! Legt fest, ob nur autorisierte User zugreifen können
   $sec["auth_requested"] = 1;

include($ttl_root . "includes/top_box.php");

$pic_uid = $_GET["uid"];

$getinfos = mysql_query("SELECT
                                    ttl_galleries_nick.uid as uid,
                                    ttl_galleries_nick.user_id as user_id,
                                    ttl_galleries_nick.stamp as stamp,
                                    ttl_comments_nick.pic_uid as pic_uid
                                FROM
                                    ttl_galleries_nick,
        ttl_comments_nick
                                WHERE
                                    ttl_galleries_nick.uid = '$pic_uid'
                                LIMIT 1       ");

if($sec["logged"])
{
 if($user[13] == "admin" || $user[13] == "mod")
 {
  if($row = mysql_fetch_array($getinfos))
      {

$user_id = $row["user_id"];
  $stamp = $row["stamp"];
  $pic_uid = $row["pic_uid"];

$pic = $user_id."_".$stamp;
  $pic2 = "./galeriepics/".$user_id."_".$stamp.".jpg";

unlink($pic2);

$del_pic = mysql_query(" DELETE  FROM ttl_galleries_nick
      WHERE ttl_galleries_nick.pic = '" . $pic . "'
      LIMIT 1       ") or die(mysql_error());

$getinfo      = mysql_query("SELECT COUNT(*) FROM ttl_comments_nick WHERE ttl_comments_nick.pic_uid = '$pic_uid'");
$noc      = mysql_fetch_row($getinfo);
echo $noc[0];

$del_comments = mysql_query(" DELETE  FROM ttl_comments_nick
      WHERE ttl_comments_nick.pic_uid = '" . $pic_uid . "'
             LIMIT $noc[0]    ") or die(mysql_error());

if($del_pic & $del_comments)
  {
   echo "<tr><td align=center class=text_C30000><br><b>Gelöscht!</b><br><br></td></tr>";
  }
  else
  {
   echo "<tr><td align=center class=text_C30000><br><b>Fehler beim löschen!</b><br><br></td></tr>";
  }

}

}
 else
 {
  echo "<tr><td align=center class=text_C30000><br><b>Fehler!</b><br><br></td></tr>";
 }
}
else
{
?>
<tr><td align=center><span class="text_C30000"><b>Du hast nicht die erforderlichen Rechte, um auf diesen Bereich zugreifen zu können.</b></span></td></tr>
<?
}

include($ttl_root . "includes/bottom_box.php");

?>