THEMA: PHP Fehler

Könntet ihr mir helfen dies ist ein eignes PHP Programm für Funkspiele.

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/virtual/virtuelle-lst.de/demo1/htdocs/index.php on line 16 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/virtual/virtuelle-lst.de/demo1/htdocs/index.php on line 18 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/virtual/virtuelle-lst.de/demo1/htdocs/index.php on line 20 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/virtual/virtuelle-lst.de/demo1/htdocs/index.php on line 22 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/virtual/virtuelle-lst.de/demo1/htdocs/index.php on line 24 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/virtual/virtuelle-lst.de/demo1/htdocs/index.php on line 26 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/virtual/virtuelle-lst.de/demo1/htdocs/index.php on line 28 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/virtual/virtuelle-lst.de/demo1/htdocs/index.php on line 32 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/virtual/virtuelle-lst.de/demo1/htdocs/index.php on line 34 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/virtual/virtuelle-lst.de/demo1/htdocs/index.php on line 50

Hallo,

die Funktion mysql_fetch_array() kann sowohl einen boolschen Wert als auch ein Array zurückgeben. Die Fehlermeldungen oben weisen darauf hin, dass in dem vorangegangenen MySQL-Statement ein Fehler aufgetreten ist.

Viele Grüße,
Grogster

Danke und wie kann ich den Fehler beheben

Hallo,

so ohne Quellcode kann ich das leider nicht sagen, in der index.php wird in Zeile 16 wohl mysql_fetch_array() aufgerufen. Das MySQL-Statement, das kurz davor steht enthält irgendeinen Fehler (z.B. Fehler in der Struktur des MySQL Befehls, Felder existieren nicht, Tabelle existiert nicht,...). In PhpMyAdmin kann über den SQL-Tab (www.siteground.com/img/knox/tutorials/up...es/phpmyadmin/33.jpg) direkt ein MySQL-Statement ausgeführt werden. Dort kommen dann spezifischere Fehlermeldungen.

Viele Grüße,
Grogster

Hier der quell Text von Index.php

<?php
ini_set('session.gc_maxlifetime', 3600);
ini_set('session.gc_divisor', 1);
session_start();
mysql_connect("**************", "U1599219", "*********") or die(mysql_error());
mysql_select_db("DB1599219") or die(mysql_error());
$datum1 = date("d.m.Y");
$datum2 = date("H:i");
$datumf = $datum1." - ".$datum2;
include ("includes/functions.php");
if(!empty($_SESSION))
{
mysql_query("UPDATE user SET last_hit = '".$datumf."', `lasthit` = NOW() WHERE Id = '".$_SESSION["ID"]."'");

}
$daten = mysql_fetch_array(mysql_query("SELECT * FROM leitstelle WHERE id = '1'"));
$result9 = mysql_query("SELECT * FROM einsaetze WHERE gesch = '0' ");
$num_rows9 = mysql_num_rows($result9);
$resultes = mysql_query("SELECT * FROM einsaetze");
$num_rowses = mysql_num_rows($resultes);
$result2 = mysql_query("SELECT * FROM user");
$num_rows2 = mysql_num_rows($result2);
$result3 = mysql_query("SELECT * FROM wachen");
$num_rows3 = mysql_num_rows($result3);
$result4 = mysql_query("SELECT * FROM fahrzeuge");
$num_rows4 = mysql_num_rows($result4);
$result5 = mysql_query("SELECT * FROM user WHERE online = '1' ");
$num_rows5 = mysql_num_rows($result5);

$bnk = $_SESSION["BN"];
$resultpn = mysql_query("SELECT * FROM PM WHERE `to` = '$bnk'");
$num_rowspn = mysql_num_rows($resultpn);
$resultpn2 = mysql_query("SELECT * FROM PM WHERE status = 'NEU' AND `to` = '".$_SESSION["BN"]."'");
$num_rowspn2 = mysql_num_rows($resultpn2);

$sizquery = 'SHOW TABLE STATUS FROM `DB1599219`;';
$sizeresult = mysql_query($sizquery) OR die(mysql_error());
$tblsize=0;
while($each_table = mysql_fetch_assoc($sizeresult))
{
$tblsize+= intval($each_table);
}
if($num_rowspn2 > 0){
$message = '<div class="fehler">Du hast '.$nun_rowspn2.' ungelesene Nachrichten!</div>';
$pncolor = "F7AE05";
}
$sql1 = " SELECT count(*) AS `anzahl` FROM `user`
WHERE `lasthit` > DATE_SUB(NOW(), INTERVAL 10 MINUTE)";
$res = mysql_query($sql1); // $res in gewohnter Weise auswerten
$rows = mysql_fetch_assoc($res);
$rechtedata = explode(",", $_SESSION["rechte"]);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="description" content="<? echo $daten["meta_b"]; ?>" />
<meta name="keywords" content="<? echo $daten["metas"]; ?>">
<meta name="author" content="<? echo $daten["autor"]; ?>, Norman Gelhausen">
<title><? echo $daten["browstitel"]; ?> </title>
<script type="text/javascript" src="ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>
<script type="text/javascript" src="jquery.hoverIntent.minified.js"></script>
<link rel="stylesheet" href="style.css" type="text/css" />
<script type="text/javascript" src="js/jquery-1.4.4.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.8.11.custom.min.js"></script>
<script type="text/javascript">
(function(window, document, undefined){
var XBTooltip = function( element, userConf, tooltip) {
var config = {
id: userConf.id|| undefined,
className: userConf.className || undefined,
x: userConf.x || 20,
y: userConf.y || 20,
text: userConf.text || undefined
};
var over = function(event) {
tooltip.style.display = "block";
},
out = function(event) {
tooltip.style.display = "none";
},
move = function(event) {
event = event ? event : window.event;
if ( event.pageX == null && event.clientX != null ) {
var doc = document.documentElement, body = document.body;
event.pageX = event.clientX + (doc && doc.scrollLeft || body && body.scrollLeft || 0) - (doc && doc.clientLeft || body && body.clientLeft || 0);
event.pageY = event.clientY + (doc && doc.scrollTop || body && body.scrollTop || 0) - (doc && doc.clientTop || body && body.clientTop || 0);
}
tooltip.style.top = (event.pageY+config.y) + "px";
tooltip.style.left = (event.pageX+config.x) + "px";
}
if (tooltip === undefined && config.id) {
tooltip = document.getElementById(config.id);
if (tooltip) tooltip = tooltip.parentNode.removeChild(tooltip)
}
if (tooltip === undefined && config.text) {
tooltip = document.createElement("div");
if (config.id) tooltip.id= config.id;
tooltip.innerHTML = config.text;
}
if (config.className) tooltip.className = config.className;
tooltip = document.body.appendChild(tooltip);
tooltip.style.position = "absolute";
element.onmouseover = over;
element.onmouseout = out;
element.onmousemove = move;
over();
};
window.XBTooltip = window.XBT = XBTooltip;
})(this, this.document);

$(document).ready(function(){

$("ul.subnav").parent().append("<span></span>"); //Only shows drop down trigger when js is enabled (Adds empty span tag after ul.subnav*)

$("ul.topnav li span").click(function() { //When trigger is clicked...

//Following events are applied to the subnav itself (moving subnav up and down)
$(this).parent().find("ul.subnav").slideDown('fast').show(); //Drop down the subnav on click

$(this).parent().hover(function() {
}, function(){
$(this).parent().find("ul.subnav").slideUp('slow'); //When the mouse hovers out of the subnav, move it back up
});

//Following events are applied to the trigger (Hover events for the trigger)
}).hover(function() {
$(this).addClass("subhover"); //On hover over, add class "subhover"
}, function(){ //On Hover Out
$(this).removeClass("subhover"); //On hover out, remove class "subhover"
});

});
function UR_Start()
{
UR_Nu = new Date;
UR_Indhold = showFilled(UR_Nu.getHours()) + ":" + showFilled(UR_Nu.getMinutes()) + ":" + showFilled(UR_Nu.getSeconds());
document.getElementById("ur").innerHTML = UR_Indhold;
setTimeout("UR_Start()",1000);
}
function showFilled(Value)
{
return (Value > 9) ? "" + Value : "0" + Value;
}
function toggleDiv(element){
if(document.getElementById(element).style.display == 'none')
document.getElementById(element).style.display = 'block';
else
document.getElementById(element).style.display = 'none';
}

function checkedall(checked)
{
for (var i = 2; i < document.forms[0].elements.length; i++) {
document.forms[0].elements.checked = checked;
}
}
</script>
</head>
<body onload="UR_Start()">
<?
if(!isset($_SESSION["ID"])){
?>


<center>
<div id="header"><div style="width:80%"><img src="images/logob.png" height="98" align="left" /></div></div>
<div id="wrapper">
<div id="menu"><h1>Funkspiel - Leitstelle</h1></div>
<div id="loginbox">
<center>
<p><strong>Herzlich Willkommen in der Leitstelle!</strong></p>
<p>Bitte melden sie sich mit ihren Logindaten an!</p>
</center><? if($_GET["step"] == "login"){ include("page/user/login.php"); }
else {?>
<form id="form1" name="login" method="post" action="index.php?step=login">
<table width="302" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="101" height="40"><label for="bn">Benutzername:</label></td>
<td width="201" height="40">
<input name="bn" type="text" class="textfeld" id="bn" /></td>
</tr>
<tr>
<td height="40"><label for="pw">Passwort:</label></td>
<td height="40">
<input name="pw" type="password" class="textfeld" id="pw" /></td>
</tr>
<tr>
<td height="40"> </td>
<td height="40"><input type="submit" name="button" id="button" value="Einloggen" /></td>
</tr>
</table>
</form>
<? } ?>
<center>Zurzeit sind <?
if($rows == "0"){
echo'keine';

}
else{echo''.$rows[anzahl].'';}
$udata = mysql_fetch_array(mysql_query("SELECT * FROM user WHERE Id = '".$_SESSION["ID"]."' "));
?> Benutzer Eingeloggt.</center>
<br />
<div id="toggle" <? if($_GET["step"] == "reg"){?>style="text-align:left;"<? }else{?>style="display:none; text-align:left;" <? }?>>
<? include("registration.php"); ?>
</div>
<div id="pwd" style="display:none; text-align:left;">
<b>Passwort Vergessen</b>
<center>Wenn du dein Passwort Vergessen hast gebe hier deine E-Mail Adresse und deinen Benutzer ein, danach wird ein neues Passwort generiert und dir per E-Mail zugesendet.</center>


<form id="form2" name="pwd" method="post" action="index.php?step=pwd">
<table width="278" border="0" align="center">
<tr>
<td width="121" align="left" scope="row">Benutzername:</td>
<td width="147"><label for="bn"></label>
<input name="bn" type="text" class="textfeld" id="bn" /></td>
</tr>
<tr>
<td align="left" scope="row">E-Mail:</td>
<td><label for="pw"></label>
<input name="mail" type="text" class="textfeld" id="text" />
<input type="hidden" name="newpw" id="hiddenField" value="" /></td>
</tr>
<tr>
<td colspan="2" align="center" valign="middle"><input type="submit" name="button" id="button" value="Passwort Senden" /></td>
</tr>
</table>
<br /></form>
</div>
<div id="notruf" <? if($_GET["step"] == "notruf"){?>style="text-align:left;"<? }else{?>style="display:none; text-align:left;" <? }?>>
<?
if($_GET["step"] == "notruf"){

//Fehler array
$fehler = array();
//Inhaltsüberprüfung
if(empty($_POST)) {
$fehler = 'Sie müssen einen Namen angeben';
}
if (empty($fehler)) {
mysql_query("INSERT INTO notrufe (name, tel, strasse, nr, ort, lage, obj) VALUES ('".$_POST["name"]."', '".$_POST["tel"]."', '".$_POST["strasse"]."', '".$_POST["hnr"]."', '".$_POST["ort"]."', '".$_POST["lage"]."', '".$_POST["obj"]."')") or die (mysql_error());
$datum1 = date("d.m.Y");
$datum2 = date("H:i:s");
$datumf = $datum1." - ".$datum2;
echo '<div class="jes">Der Notruf wurde Abgesetzt</div><br>';
} else {

// Ausgabe der gesammelten Fehlermeldungen
echo "<div class='fehler'><b>Es wurden Folgende Fehler bei der Verarbeitung des Formulars Gefunden:</b><br> <ul>\n";
foreach ($fehler as $feldname => $meldung) {
printf("<li>%s</li>\n", htmlspecialchars($meldung));
}
echo "</ul></div>\n";

}

}

$num_notrufe = mysql_num_rows(mysql_query("SELECT * FROM notrufe WHERE alarm = ''"));
if($num_notrufe < 5){
echo' <h1>Notruf Absetzen</h1>
<br><center><font color="#ff0000"><b>Hinweis in eigener sache: Hier können sie KEINEN ECHTEN NOTRUF Absetzen!</b></font></center>
<form id="form1" name="newuser" method="post" action="index.php?step=notruf">
<table width="80%" border="0">
<tr>
<td height="20" colspan="2" align="left" valign="middle" scope="row"><strong>Persöhnliche Informationen</strong></td>
<td height="20" colspan="2" valign="middle"> </td>
</tr>
<tr>
<td width="27" align="left" valign="middle" scope="row"> </td>
<td width="206" height="20" align="left" valign="middle" scope="row">Wie ist dein Name?</td>
<td height="20" colspan="2" valign="middle"><label for="name"></label>
<label for="name"></label>
<input name="name" type="text" class="textfeld" id="name" size="40" /></td>
</tr>
<tr>
<td align="left" valign="middle" scope="row"> </td>
<td height="20" align="left" valign="middle" scope="row">Wie ist deine Telefonnummer?</td>
<td height="20" colspan="2" valign="middle"><label for="tel"></label>
<input type="text" name="tel" id="tel"></td>
</tr>
<tr>
<td height="20" colspan="2" align="left" valign="middle" scope="row"><strong>Einsatzort</strong></td>
<td height="20" colspan="2" valign="middle"> </td>
</tr>
<tr>
<td align="left" valign="middle" scope="row"> </td>
<td height="20" align="left" valign="middle" scope="row">Strasse:</td>
<td height="20" colspan="2" valign="middle"><label for="strasse"></label>
<select name="strasse" id="strasse">
<option>Bitte Strasse Wählen </option>
<optgroup label="Wohngebiet">
';
$streetd0 = mysql_query("SELECT * FROM `strassen` WHERE gebiet = 'Wohngebiet' ORDER BY `id` DESC");
while($street0 = mysql_fetch_assoc($streetd0))
{
echo'

<option value="'.$street0["name"].'">'.$street0["name"].'</option>

';
} echo'</optgroup>
<optgroup label="Industriegebiet">';
$streetd1 = mysql_query("SELECT * FROM `strassen` WHERE gebiet = 'Industriegebiet' ORDER BY `id` DESC");
while($street1 = mysql_fetch_assoc($streetd1))
{
echo'

<option value="'.$street1["name"].'">'.$street1["name"].'</option>

';
} echo'</optgroup>
<optgroup label="Gewerbegebiet">';
$streetd2 = mysql_query("SELECT * FROM `strassen` WHERE gebiet = 'Gewerbegebiet' ORDER BY `id` DESC");
while($street2 = mysql_fetch_assoc($streetd2))
{
echo'

<option value="'.$street2["name"].'">'.$street2["name"].'</option>

';
} echo'</optgroup>
<optgroup label="Autobahn">';
$streetd3 = mysql_query("SELECT * FROM `strassen` WHERE gebiet = 'Autobahn' ORDER BY `id` DESC");
while($street3 = mysql_fetch_assoc($streetd3))
{
echo'

<option value="'.$street3["name"].'">'.$street3["name"].'</option>

';
} echo'</optgroup>
<optgroup label="Bundesstrassen">';
$streetd4 = mysql_query("SELECT * FROM `strassen` WHERE gebiet = 'Bundesstrassen' ORDER BY `id` DESC");
while($street4 = mysql_fetch_assoc($streetd4))
{
echo'

<option value="'.$street4["name"].'">'.$street4["name"].'</option>

';
} echo'</optgroup>
<optgroup label="Landstrassen">
';
$streetd5 = mysql_query("SELECT * FROM `strassen` WHERE gebiet = 'Landstrassen' ORDER BY `id` DESC");
while($street5 = mysql_fetch_assoc($streetd5))
{
echo'

<option value="'.$street5["name"].'">'.$street5["name"].'</option>

';
}
echo'

</select>
Hausnummer:
<label for="hnr"></label>
<input type="text" name="hnr" id="hnr"></td>
</tr>
<tr>
<td align="left" valign="middle" scope="row"> </td>
<td height="20" align="left" valign="middle" scope="row">Ort:</td>
<td height="20" colspan="2" valign="middle"><label for="ort"></label>
<input name="ort" type="text" id="ort" size="40"></td>
</tr>
<tr>
<td height="20" colspan="2" align="left" valign="middle" scope="row"><strong>Einsatzstelle</strong></td>
<td height="20" colspan="2" valign="middle"> </td>
</tr>
<tr>
<td align="left" valign="middle" scope="row"> </td>
<td height="20" align="left" valign="middle" scope="row">Was ist Passiert?</td>
<td height="20" colspan="2" valign="middle"><label for="lage"></label>
<input name="lage" type="text" class="textfeld" id="lage" size="60" /></td>
</tr>
<tr>
<td align="left" valign="middle" scope="row"> </td>
<td height="20" align="left" valign="middle" scope="row">Welches Objekt?</td>
<td height="20" colspan="2" valign="middle"><label for="obj"></label>
<input name="obj" type="text" class="textfeld" id="obj" size="40" /></td>
</tr>
<tr>
<td width="27" align="left" valign="middle" scope="row"> </td>
<td width="206" height="20" align="left" valign="middle" scope="row"> </td>
<td height="20" valign="middle"><a href="javascript:document.newuser.submit();" class="button0">Notruf Senden</a></td>
<td width="564" height="20" valign="middle"> </td>
</tr>
<tr>
<th width="27" align="left" valign="middle" scope="row"> </th>
<th width="206" height="20" align="left" valign="middle" scope="row"> </th>
<td width="453" height="20" align="left" valign="middle"> </td>
<td height="20" valign="middle"> </td>
</tr>
</table>
<p> </p>
</form>';} else{echo'<div class="fehler">Zurzeit sind leider Alle Notrufleitungen Belegt!</div>';} ?>
</div>
<div id="nutz" style="text-align:left; display:none"><b>Nutzungsbedingungen</b><br /><? echo nl2br($daten["nb"]); ?><br /><br /></div>
<div id="datensch" style="text-align:left; display:none"><b>Datenschutz</b><br /><? echo nl2br($daten["ds"]); ?><br /><br /></div>
<br />
<? echo'
<p><strong>Letzten Einsätze</strong></p>
<ul>';
$datenholen99 = mysql_query("SELECT * FROM `einsaetze` ORDER BY `id` DESC LIMIT 5");
while($row99 = mysql_fetch_assoc($datenholen99))
{
$titel99 = $row99["Lage"];
$rest99 = substr("".$titel99."", 0, 50);
echo'<li><font class="enr">.']:</font><a href="index.php?page=einsatz/fax&id='.$row99["id"].'">'.$rest99.'...</a></li>';
}?>
</ul>
<p> </p>
</div>

</div>
<div id="footer"><br />
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="33%" align="left"><a href="Javascript:toggleDiv('nutz');" class="footerl">Nutzungsbedingungen</a> | <a href="Javascript:toggleDiv('datensch');" class="footerl">Datenschutz</a> | <a href="Javascript:toggleDiv('pwd');" class="footerl">Passwort Vergessen?</a> | <a href="Javascript:toggleDiv('toggle');" class="footerl">Registrieren</a> | <a href="Javascript:toggleDiv('notruf');" class="footerl">Notruf Absetzen</a>  </td>
<td width="33%" align="center">Funkspiel Leitstelle Version <? echo $daten["version"] ?> </td>
<td width="33%" align="right">Copyright © 2010 - <? echo date("Y"); ?> <a href="Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!" class="footerl">Norman Gelhausen</a>. Alle Rechte vorbehalten. </td>
</tr>
</table><br />
</div>
</center>
<? } else{ ?>
<center>
<div id="header"><div style="width:80%;"><img src="images/logob.png" height="98" align="left" /><span style="font-size:24px; font-weight:bold; margin-top:30px; color:#C40505; vertical-align:middle;"><? echo date("d.m.Y - "); ?><font id="ur" style="font-size:24px; font-weight:bold;"></font></span></div></div>
<div id="wrapper">
<div id="menu">
<div class="art-nav">
<div class="art-nav-l"></div>
<div class="art-nav-r"></div>
<div class="art-nav-outer">
<?
if($_SESSION["Rank"] != "Super Administrator"){}else{ include("includes/admin.php");}
if($_SESSION["Rank"] != "Administrator") {}else{include("includes/admin.php");}
if($_SESSION["Rank"] != "Disponent") {} else{include("includes/dispo.php");}
if($_SESSION["Rank"] != "User") {}else {include("includes/user.php");}
?>
</div>
</div>
<div class="cleared reset-box"></div>
</div>
<?

$num_notrufe = mysql_num_rows(mysql_query("SELECT * FROM notrufe WHERE alarm = ''"));
if($num_notrufe > 0 ){
if(in_array('Einsatzdisponieren', $rechtedata)){

echo '<div id="message"><div class="info">Es existieren <b>'.$num_notrufe.'</b> Unbearbeitete Notrufe!</div></div>';
}
}
if($num_rowspn2 > 0){
echo '<div id="message"><div class="info">Du hast <b>'.$num_rowspn2.'</b> ungelesene Nachricht(en) in deinem Postfach!</div></div>';
}
if($_GET["action"] == "comment"){
$was = array("ä", "ö", "ü", "Ä", "Ö", "Ü", "ß");
$wie = array("ä", "ö", "ü", "Ä", "Ö", "Ü", "ß");


$text = str_replace($was, $wie, $_POST["text"]);
mysql_query("INSERT INTO comments (text, datum, autor) VALUES ('".$text."', '".date("Y-m-d H:i")."', '".$_SESSION["BN"]."')") or die (mysql_error());
echo '<div id="message"><div class="jes">Dein Kommentar zu >>>Wie findest du die Funkspiel Leitstelle wurde Gespeichert!<<<</div></div>';
}
if($_GET["page"] == ""){
echo'<div id="message">
<div style="background:#FFF3BF; text-align:left; padding:5px;"><h1>Wie findest du die Version '.$daten["version"].'?</h1><center>Hier kannst du Kommentare Loswerden oder mit anderen über diese Leitstelle Diskutieren!</center>';
echo' <form id="form3" name="form3" method="post" action="index.php?action=comment">
<label for="text2"> Kommentar</label>
<input name="text" type="text" id="text2" size="99" />
<input type="submit" name="button2" id="button2" value="Kommentar Speichern" />
</form><br><script language="JavaScript">
$(document.body).ready(function (){
setTimeout("reload();", 4600);
});
function reload(){
$.ajax({
url: "request_comments.php",
success: function(data){
$(".comments_view").html(data);
}
});
setTimeout("reload();", 4600);
}
//window.setTimeout("location.reload()",5000);
</script>
<div class="comments_view">';

$comment_data = mysql_query("SELECT * FROM `comments` ORDER BY `datum` DESC LIMIT 10");
while($comment = mysql_fetch_assoc($comment_data))
{
$dateall = mysql_fetch_array(mysql_query("SELECT DATE_FORMAT(`datum`, '%d.%m.%Y - %H:%i') AS `date` FROM `comments` WHERE `id` = '".$comment["id"]."'"));
echo'<b>'.$comment["autor"].' schrieb am '.$dateall["date"].':</b>
<br>     '.$comment["text"].'<br><br>';
}echo'</div></div></div>';}
?>

<div id="content">
<?
if(isset($_GET["page"])){
if(file_exists("page/".$_GET["page"].".php")){
include("page/".$_GET["page"].".php");
echo'<br><img src="images/edit_user.png" align="absmiddle" border="" width="16" />
';
switch ($rows[anzahl])
{
case 1:
echo ''.$rows[anzahl].'/';
break;
default:
echo ''.$rows[anzahl].'/';
break;
}
$udata = mysql_fetch_array(mysql_query("SELECT * FROM user WHERE Id = '".$_SESSION["ID"]."' "));
echo $num_rows2;?> <img src="images/laufendeeinsatze.png" alt="Laufende Einsätze" onmouseover="XBT(this, {text: 'Einsätze<br>Laufende/Gesammt', className: 'xbtooltip'})" align="absmiddle" border=""

width="16" /><? echo $num_rows9;?>/<? echo $num_rowses;?> <img src="images/create.png" alt="Uhrzeit" align="absmiddle" border="" width="16" /><? echo $datum1; ?> <font id="ur" ></font> 
<a href="index.php?page=pm/inbox"><img src="images/pm.png" alt="Nachrichten" align="absmiddle" border="" width="16" onmouseover="XBT(this, {text: 'Private Nachrichten', className: 'xbtooltip'})" /></a>
<? if($num_rowspn2 == 0){
echo'Keine neuen Nachrichten';
}
else {
echo '<font style="color:#ff0000; font-weight: bold;">'.$num_rowspn2.' neue Nachrichte(n)!</font>';
} ?><img src="images/database.png" onmouseover="XBT(this, {text: 'Der benötigte speicher in der Mysql Datenbank', className: 'xbtooltip'})" alt="Datenbankgröße"

align="absmiddle" border="" width="16" /><? echo number_format($tblsize/1024/1024,2,",",".")." MB"; ?> <img src="images/rights.png" alt="Deine Position in der Wache" onmouseover="XBT(this, {text: 'Deine Position in der Wache', className: 'xbtooltip'})" align="absmiddle" border="" width="16" /> <? echo $udata["titel"]; ?> <img src="images/wetter/<? $config = mysql_fetch_array(mysql_query("SELECT * FROM wetter WHERE id = '1'")); echo $config;?>.png" height="22" align="absmiddle"> Wetterlage: <?
echo''.$config.', '.$config.'';?>°C
<? }else{
include("404.php");
}
}
else{

echo'<h1>Herzlich Willkommen in der Leitstelle!</h1>
<p></p>
<p><br>
<a href="virtuelle-lst.de/">Fehler gefunden? Hier gehts Lang!</a>
<br>
<a href="index.php?page=pm/write&to=Norman">Hier kannst du eine Nachricht an den Entwickler Senden.</a> </p>
<p><strong>Letzten Einsätze</strong></p>
<ul>';
$datenholen99 = mysql_query("SELECT * FROM `einsaetze` ORDER BY `id` DESC LIMIT 5");
while($row99 = mysql_fetch_assoc($datenholen99))
{
$titel99 = $row99["Lage"];
$rest99 = substr("".$titel99."", 0, 50);
echo'<li><font class="enr">.']:</font><a href="index.php?page=einsatz/fax&id='.$row99["id"].'">'.$rest99.'...</a></li>';
}echo'
</ul>
<p><strong>Letzten Systemnachrichten</strong></p>
<ul>';
$datenholen = mysql_query("SELECT * FROM `sys_message` ORDER BY `id` DESC LIMIT 5");
while($row = mysql_fetch_assoc($datenholen))
{
$titel = $row["titel"];
$rest = substr("".$titel."", 0, 50);
echo'<li><a href="index.php?page=pm/sysread&id='.$row["id"].'">'.$rest.'</a></li>';
}echo'
</ul>
<p><a href="index.php?page=notruf/neu"><img src="images/notruf.jpg" style="border: medium none;" height="200"></a></p>
';

}?>
</div>
</tbody></table><br><br><img src="images/edit_user.png" align="absmiddle" border="" width="16">
1/2 <img src="images/laufendeeinsatze.png" alt="Laufende Einsätze" onmouseover="XBT(this, {text: 'Einsätze<br>Laufende/Gesammt', className: 'xbtooltip'})" align="absmiddle" border="" width="16">10/12 <img src="images/create.png" alt="Uhrzeit" align="absmiddle" border="" width="16">20.03.2014 <font id="ur"></font> 
<a href="index.php?page=pm/inbox"><img src="images/pm.png" alt="Nachrichten" onmouseover="XBT(this, {text: 'Private Nachrichten', className: 'xbtooltip'})" align="absmiddle" border="" width="16"></a>
Keine neuen Nachrichten<img src="images/database.png" onmouseover="XBT(this, {text: 'Der benötigte speicher in der Mysql Datenbank', className: 'xbtooltip'})" alt="Datenbankgröße" align="absmiddle" border="" width="16">0,02 MB <img src="images/rights.png" alt="Deine Position in der Wache" onmouseover="XBT(this, {text: 'Deine Position in der Wache', className: 'xbtooltip'})" align="absmiddle" border="" width="16"> <img src="images/wetter/.png" align="absmiddle" height="22"> Wetterlage: , °C
</div>
<div id="footer"><br />
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="">
<tr>
<td width="33%" align="left"><a href="Javascript:toggleDiv('nutz');" class="footerl">Nutzungsbedingungen</a> | <a href="Javascript:toggleDiv('datensch');" class="footerl">Datenschutz</a> | <a href="index.php?page=notruf/neu" class="footerl">Notruf Absetzen</a>  </td>
<td width="33%" align="center">Funkspiel Leitstelle Version <? echo $daten["version"] ?> </td>
<td width="33%" align="right">Copyright © - <? echo date("Y"); ?> <a href="Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!" class="footerl">Norman Gelhausen</a>. Alle Rechte vorbehalten. </td>
</tr>
</table><br />
</div>
</center>
<? } ?>
</body>
</html>

Wenn ich diese beiden Zeilen vergleiche fällt mir zumindest mal auf, dass einmal "Id" aktualisiert wird und einmal auf "id" zugegriffen wird. Könnte das der Fehler sein?

Viele Grüße,
Grogster