note 48711 added to function.mysql-free-result

<? // error-variable wir auf false gesetzt $err = false; // falls keine kundennr uebertragen worden ist, dann setze // error-variable auf true uns gebe error-msg aus if ($usernr == "") { echo "Es wurde kein User selektiert<br><br>"; echo "<a href='javascript:history.back();'>ZURÜCK</a>"; $err = true; } // wenn kein fehler aufgetreten ist if ($err=== false) { // Standart DB Connect variablen $server = "localhost"; $database = "autovermietung"; $username = ""; $password = ""; // SQL Connect Anweisung - Wahl der Datenbank $Verbindung=mysql_connect($server) or die (mysql_error()); $DB = mysql_select_db($database,$Verbindung); // Select Statements $Query = "SELECT kundennr, nachname, vorname, strasse, plz, ort FROM kunde WHERE kundennr=$usernr"; $QueryOrder = " ORDER BY Nachname ASC"; // Anfrage an db stellen inkl WHERE-Klausel und Order BY $mysqlQuery = mysql_query($Query.$QueryOrder) or die (mysql_error()); // wenn user gefunden - anzeigen if ($row=mysql_fetch_array($mysqlQuery, MYSQL_ASSOC)) { echo "<html><head><title>EDITIEREN</title></head><body>"; echo "<form name=edit action=eintragen.php?typ=edit method=post>\r\n"; echo "<input type=hidden name=kundennr value=$usernr>\r\n"; echo "<table cellpadding=2 cellspacing=2 border=1>\r\n"; echo "<tr>\r\n"; echo "<td colspan=2>EDIT DB USER:</td>\r\n"; echo "</tr>\r\n"; echo "<tr>\r\n"; echo "<td>Vorname</td>\r\n"; echo "<td><input type=text name=Vorname value=" . $row["vorname"] . "> </td>\r\n"; echo "</tr>\r\n"; echo "<tr>\r\n"; echo "<td>Nachname</td>\r\n"; echo "<td><input type=text name=Nachname value=" . $row["nachname"] ."> </td>\r\n"; echo "</tr>\r\n"; echo "<tr>\r\n"; echo "<td>Strasse</td>\r\n"; echo "<td><input type=text name=Strasse value=" . $row["strasse"] . "> </td>\r\n"; echo "</tr>\r\n"; echo "<tr>\r\n"; echo "<td>PLZ</td>\r\n"; echo "<td><input type=text name=PLZ value=" . $row["plz"] . "> </td>\r\n"; echo "</tr>\r\n"; echo "<tr>\r\n"; echo "<td>ORT</td>\r\n"; echo "<td><input type=text name=Ort value=" . $row["ort"] ."> </td>\r\n"; echo "</tr>\r\n"; echo "<tr>\r\n"; echo "<td><a href='javascript:history.back();'>zur&uuml;ck</a> </td>\r\n"; echo "<td><a href='javascript:document.forms[0].submit();'>senden</a> </td>\r\n"; echo "</tr>\r\n"; echo "</table>\r\n"; echo "</body>\r\n"; echo "</html>\r\n"; } } // ende if err===false ?> ---- Manual Page -- http://www.php.net/manual/en/function.mysql-free-result.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+48711 Delete -- http://master.php.net/manage/user-notes.php?action=delete+48711&report=yes Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+48711&report=yes&reason=bad+code Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+48711&report=yes&reason=spam Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+48711&report=yes&reason=useless+example Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+48711&report=yes&reason=contains+commercial+links Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+48711&report=yes&reason=useless+note Reject -- http://master.php.net/manage/user-notes.php?action=reject+48711&report=yes Search -- http://master.php.net/manage/user-notes.php