Hallo
Bei der Ausgabe meiner Datenbank kommt immer die Datenbankausgabe wie gewohnt (was komisch ist) ... jedoch MIT einer Fehlermeldung oben drüber:
error begin-------------------------------------------------------------
Warning: Unable to jump to row 0 on MySQL result index 7 in /www/htdocs/dataindy/systemcar/private_msg.php on line 296
Warning: Unable to jump to row 0 on MySQL result index 7 in /www/htdocs/dataindy/systemcar/private_msg.php on line 297
error end-------------------------------------------------------------
Die besagten Zeilen 296 und 297 sehen wie folgt aus:
code begin-------------------------------------------------------------
$msg_exp = mysql_result($search_user,0,"username");
$msg_avatar = mysql_result($search_user,0,"photo");
code end-------------------------------------------------------------
der code dadrüber ist dabei:
code begin-------------------------------------------------------------
<?
$result_sql = mysql_query("SELECT * FROM private_msg WHERE to_userid = '$id' ORDER BY msg_time desc");
$nb_result = mysql_numrows($result_sql);
if ($nb_result == 0)
{
echo "<td colspan=6 bgcolor="#d8d8d8" align=center>Sie haben keine Mitteilungen</td>";
}
else
{
$i = 0;
while ($i < $nb_result)
{
$msg_id = mysql_result($result_sql,$i,"msg_id");
$msg_img = mysql_result($result_sql,$i,"msg_image");
$msg_sujet = mysql_result($result_sql,$i,"msg_sujet");
$msg_exp = mysql_result($result_sql,$i,"from_userid");
$msg_time = mysql_result($result_sql,$i,"msg_time");
$msg_text = mysql_result($result_sql,$i,"msg_text");
$msg_read = mysql_result($result_sql,$i,"read_msg");
$date1=explode(" ", $msg_time);
$date2=explode("-", $date1[0]);
$msg_time = $date2[2]." ".$date2[1]." ".$date2[0]." ".$date1[1];
if ($msg_read == 0)
$read = "<img src='images/read.gif' border='0' alt='non lu' title='non lu'>";
else
$read = " ";
$search_user = mysql_query("SELECT * FROM $dbtable WHERE id = '$msg_exp' ");
$nb_search = mysql_numrows($search_user);
$msg_exp = mysql_result($search_user,0,"username"); // Zeile 296
$msg_avatar = mysql_result($search_user,0,"photo"); // Zeile 297
code end-------------------------------------------------------------
natürlich habe ich mit include die Datenbank-Login-Daten dadrüber eigefügt (config.php)!
Aber was will mir meine Datenbank mit diesem fehler sagen? =/
hilfe?
ciao