Warning: Unable to jump to row 0 on MySQL result index 4?

Lapachon · 20. Februar 2004

Hi!

Wollte mal fragen, ob jemand weis, warum hier der Fehler auftritt?
Ich hab keinen Plan mehr.

PHP:

<?
include "../opendatabase.php";
include "../database.php";

	if (isset ($_GET["user_id"])) 
	   $user_id = $_GET["user_id"]; 
	else 
	   $user_id = "";
	   
	if (isset ($_POST["res"])) 
	   $res = $_POST["res"]; 
	else 
	   $res = "";
	   
	if (isset ($_POST["num"])) 
	   $num = $_POST["num"]; 
	else 
	   $num = "";
	   
 	if (isset ($_POST["i"])) 
	   $i = $_POST["i"]; 
	else 
	   $i = "";

  if (isset ($_POST["vorname"])) 
   $vorname = $_POST["vorname"]; 
	else 
	   $vorname = ""; 
	
	if (isset ($_POST["nachname"])) 
	   $nachname = $_POST["nachname"]; 
	else 
	   $nachname = ""; 
	   
  if (isset ($_POST["action"])) 
	   $action = $_POST["action"]; 
	else 
	   $action = ""; 
	   
	if (isset ($_POST["straße"])) 
	   $straße = $_POST["straße"]; 
	else 
	   $straße = ""; 

  if (isset ($_POST["plz"])) 
	   $plz = $_POST["plz"]; 
	else 
	   $plz = ""; 
	   
	if (isset ($_POST["ort"])) 
	   $ort = $_POST["ort"]; 
	else 
	   $ort = ""; 

  if (isset ($_POST["tel"])) 
	   $tel = $_POST["tel"]; 
	else 
	   $tel = ""; 
	   
	if (isset ($_POST["fax"])) 
	   $fax = $_POST["fax"]; 
	else 
	   $fax = ""; 

  if (isset ($_POST["email"])) 
	   $email = $_POST["email"]; 
	else 
	   $email = ""; 
	   
	if (isset ($_POST["gruppe"])) 
	   $gruppe = $_POST["gruppe"]; 
	else 
	   $gruppe = ""; 

  if (isset ($_POST["heimatclub"])) 
	   $heimatclub = $_POST["heimatclub"]; 
	else 
	   $heimatclub = ""; 
	   
	if (isset ($_POST["stammvorgabe"])) 
	   $stammvorgabe = $_POST["stammvorgabe"]; 
	else 
	   $stammvorgabe = ""; 

  if (isset ($_POST["reisepartner"])) 
	   $reisepartner = $_POST["reisepartner"]; 
	else 
	   $reisepartner = ""; 
	   
	if (isset ($_POST["anmerkungen"])) 
	   $anmerkungen = $_POST["anmerkungen"]; 
	else 
	   $anmerkungen = ""; 
	   
	if (isset ($_POST["hint"])) 
	   $hint = $_POST["hint"]; 
	else 
	   $hint = ""; 
	   
	if (isset ($_POST["updatequery"])) 
	   $updatequery = $_POST["updatequery"]; 
	else 
	   $updatequery = ""; 

if (($action == "update") && (strlen($user_id) > 0)) {
   mysql_query("UPDATE register SET vorname='$vorname', nachname='$nachname', straße='$straße', plz='$plz', ort='$ort', tel='$tel', fax='$fax'") or die(mysql_error());
   $hint = "Daten wurde geändert!";
   $action = "";
}

$updatequery = "SELECT * FROM register";
$result = ExecuteQuery($updatequery);
$res = mysql_query("SELECT * FROM register");
$num = mysql_num_rows($res);
?>
<html>
<head>
</head>
	<title>Mitglied &auml;nder...</title>
<body bgcolor="#ffffff" link="#000000" alink="#000000" vlink="#000000">
<table width="50%" border="0" align="center">
	<tr>
		<td align="center">
			<font color="#000000" face="arial" size="2"><b>Registrierungsverwaltung:</b></font>
			<hr color="#000000">
		</td>
	</tr>
</table>	
<table width="50%" border="0" align="center">
<?
for ($i=0; $i< $num; $i++) {
	$res				 	= mysql_query("SELECT * FROM register WHERE user_id='$user_id' ORDER BY user_id");
	$num 					= mysql_num_rows($res);
	$user_id			= mysql_result($res, $i, "user_id");
	$vorname 			= mysql_result($res, $i, "vorname");
	$nachname			= mysql_result($res, $i, "nachname");
	$straße			 	= mysql_result($res, $i, "straße");
	$plz					= mysql_result($res, $i, "plz");
	$ort 					= mysql_result($res, $i, "ort");
	$tel					= mysql_result($res, $i, "tel");
	$fax 					= mysql_result($res, $i, "fax");
	$email				= mysql_result($res, $i, "email");
	$gruppe 			= mysql_result($res, $i, "gruppe");
	$heimatclub		= mysql_result($res, $i, "heimatclub");
	$stammvorgabe	= mysql_result($res, $i, "stammvorgabe");
	$reisepartner	= mysql_result($res, $i, "reisepartner");
	$anmerkungen 	= mysql_result($res, $i, "anmerkungen");
?>
	<tr>
	  <td colspan="2"><font color="#ffffff" face="arial" size="2"><?=$hint?></font></td>
	</tr>
		<form action="edit_registers.php" method="post">
		<input type="hidden" name="user_id" value="<?=$user_id?>">
		<input type="hidden" name="action" value="update">
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">Vorname:</font>
		</td>
		<td>
			<input type="text" name="vorname" size="20" value="<?=$vorname?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">Nachname:</font>
		</td>
		<td>
			<input type="text" name="nachname" size="20" value="<?=$nachname?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">Straße:</font>
		</td>
		<td>
			<input type="text" name="straße" size="20" value="<?=$straße?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">PLZ:</font>
		</td>
		<td>
			<input type="text" name="plz" size="10" value="<?=$plz?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
  <tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">Ort:</font>
		</td>
		<td>
			<input type="text" name="ort" size="20" value="<?=$ort?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">Tel.:</font>
		</td>
		<td>
			<input type="text" name="tel" size="20" value="<?=$tel?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">Fax:</font>
		</td>
		<td>
			<input type="text" name="fax" size="20" value="<?=$fax?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">eMail:</font>
		</td>
		<td>
			<input type="text" name="email" size="20" value="<?=$email?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">Gruppe:</font>
		</td>
		<td>
			<input type="text" name="gruppe" size="20" value="<?=$gruppe?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">Heimatclub:</font>
		</td>
		<td>
			<input type="text" name="heimatclub" size="20" value="<?=$heimatclub?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">Stammvorgabe:</font>
		</td>
		<td>
			<input type="text" name="stammvorgabe" size="20" value="<?=$stammvorgabe?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">Reisepartner:</font>
		</td>
		<td>
			<input type="text" name="reisepartner" size="20" value="<?=$reisepartner?>">&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td align="left">
			<font color="#000000" face="arial" size="2">Anmerkungen:</font>
		</td>
		<td>
			<textarea name="anmerkungen" cols="30" rows="4"><?=$anmerkungen?></textarea>&nbsp;&nbsp;<font color="#000000" face="arial" size="2"></font>
		</td>
	</tr>
	<tr>
		<td>
			<input type="submit" value="Daten speichern">
		</td>
	</tr>
	<tr>
		<td align="center">
			<font color="#000000" face="arial" size="2"><a href="edit_all.php">[zur&uuml;ck]</a></font>
		</td>
	</tr>
</table>
</form>
<?
	}
?>
</body>
</html>

Tut mir leid, dass ich den ganzen Source reingedreht hab, aber ich denke mir mal sonst könnt Ihr mir nicht weiterhelfen!

Achja, hier noch die Fehlermeldungen die kommen:

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 134

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 135

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 136

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 137

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 138

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 139

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 140

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 141

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 142

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 143

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 144

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 145

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 146

Warning: Unable to jump to row 0 on MySQL result index 4 in e:\sbx\greensclub\admin\edit_registers.php on line 147

LG

Lapachon

Gottox · 20. Februar 2004

Das bedeutet schlicht und einfach, dass dein Result keine Einträge zurückliefert...

Warning: Unable to jump to row 0 on MySQL result index 4?

Lapachon

Mitglied

Gottox

Erfahrenes Mitglied

Neue Beiträge