Fehler in Code .. bitte um Hilfe

Worka

Worka

Mitglied
Abend Leute,,
hab ein Fehler und weiß nicht warum er den anzeigt, liegt es an der Version oder so ?

Folgender Fehler:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in D:\php5xampp-dev\htdocs\maschinendatenbank\login\modify.php on line 24


PHP: 
<?

  include("config.php");

  

  if($pwd == $pwd){
    include("db_connect.php");

    echo "
        <table border='0' cellspacing='0' cellpadding='3' align='center' width='100%'>
    ";

    if($submit){
      $input_geraet = str_replace("\n","<br>",$input_geraet);
      if(mysql_query("UPDATE $db_table SET geraet = '$input_geraet', typ = '$input_typ', ident = '$input_ident', baujahr = '$input_baujahr', anschaffung = '$input_anschaffung', wert = '$input_wert', zubehoer = '$input_zubehoer', date = '$input_date' WHERE id = '$id'"))
        echo "Der neue Stand ist gespeichert!<br><a href='admin.php?pwd=$pwd'>weiter</a>";
      else
        echo "Es ist ein Fehler aufgetreten!<br><a href='JavaScript:history.back()'>zurück</a>";
    }
    else{
      mysql_select_db($db_table,$db);
      $result = mysql_query("SELECT * FROM $db_table WHERE id = '$id'");
      list($id,$geraet,$typ,$ident,$baujahr,$anschaffung,$wert,$zubehoer,$date) = mysql_fetch_row($result);

      echo "


<table cellspacing='0' cellpadding='0' border='0' width='627' align='center'>
  <tr> 
    <td height='20' align='left' valign='middle' colspan='2'> 
      <div align='center'> 
        <p><font face='verdana,tahoma,arial' color='#000033' size='1'><b><br>
          <font size='5'>-- EINGABE der Grunddaten --<br>
          Maschinen bzw. Ger&auml;te </font><br>
          </b></font></p>
        <p>&nbsp;</p>
        <p><font face='verdana,tahoma,arial' color='#000033' size='1'><b><br>
          </b></font></p>
      </div>
    </td>
  </tr>
  
<form action='modify.php?pwd=$pwd' method='post'>
          <input type='hidden' name='id' value='$id'>
    
<tr> 
      <td width='309' height='40' align='left' valign='middle'><font face='verdana,tahoma,arial' color='#000033' size='3'><b>Ger&auml;t 
        / Maschine :</b></font></td>
      <td width='318' height='40' align='left' valign='middle'> <font size='3'> 
        <input type='text' value='$geraet' name='input_geraet' size='40' style='BORDER-RIGHT: #000033 1px solid; BORDER-TOP: #000033 1px solid; BORDER-LEFT: #000033 1px solid; BORDER-BOTTOM: #000033 1px solid; COLOR: #000033; background-color:#ffffff; font-size: 10px; font-family: Verdana,Arial; text-decoration: none'>
        </font></td>
    </tr>
    
<tr> 
      <td width='309' height='40' align='left' valign='middle'><font face='verdana,tahoma,arial' color='#000033' size='3'><b>Typ 
        :</b></font></td>
      <td width='318' height='40' align='left' valign='middle'> <font size='3'> 
        <input type='text' value='$typ' name='input_typ' size='40' style='BORDER-RIGHT: #000033 1px solid; BORDER-TOP: #000033 1px solid; BORDER-LEFT: #000033 1px solid; BORDER-BOTTOM: #000033 1px solid; COLOR: #000033; background-color:#ffffff; font-size: 10px; font-family: Verdana,Arial; text-decoration: none'>
        </font></td>
    </tr>
    
<tr> 
      <td width='309' height='40' align='left' valign='middle'><font face='verdana,tahoma,arial' color='#000033' size='3'><b>Ident 
        / Typ Nr.:</b></font></td>
      <td width='318' height='40' align='left' valign='middle'> <font size='3'> 
        <input type='text' value='$ident' name='input_ident' size='40' style='BORDER-RIGHT: #000033 1px solid; BORDER-TOP: #000033 1px solid; BORDER-LEFT: #000033 1px solid; BORDER-BOTTOM: #000033 1px solid; COLOR: #000033; background-color:#ffffff; font-size: 10px; font-family: Verdana,Arial; text-decoration: none'>
        </font></td>
    </tr>
   
 <tr> 
      <td width='309' height='40' align='left' valign='middle'><font face='verdana,tahoma,arial' color='#000033' size='3'><b>Baujahr 
        :</b></font></td>
      <td width='318' height='40' align='left' valign='middle'> <font size='3'> 
        <input type='text' value='$baujahr' name='input_baujahr' size='40' style='BORDER-RIGHT: #000033 1px solid; BORDER-TOP: #000033 1px solid; BORDER-LEFT: #000033 1px solid; BORDER-BOTTOM: #000033 1px solid; COLOR: #000033; background-color:#ffffff; font-size: 10px; font-family: Verdana,Arial; text-decoration: none'>
        </font></td>
    </tr>
    
<tr> 
      <td width='309' height='40' align='left' valign='middle'><font face='verdana,tahoma,arial' color='#000033' size='3'><b>Anschaffungsdatum 
        :</b></font></td>
      <td width='318' height='40' align='left' valign='middle'> <font size='3'> 
        <input type='text' value='$anschaffung' name='input_anschaffung' size='40' style='BORDER-RIGHT: #000033 1px solid; BORDER-TOP: #000033 1px solid; BORDER-LEFT: #000033 1px solid; BORDER-BOTTOM: #000033 1px solid; COLOR: #000033; background-color:#ffffff; font-size: 10px; font-family: Verdana,Arial; text-decoration: none'>
        </font></td>
    </tr>
    
<tr> 
      <td width='309' height='40' align='left' valign='middle'><font face='verdana,tahoma,arial' color='#000033' size='3'><b>Neu- 
        bzw. Gebrauchtwert:</b></font></td>
      <td width='318' height='40' align='left' valign='middle'> <font size='3'> 
        <input type='text' value='$wert' name='input_wert' size='40' style='BORDER-RIGHT: #000033 1px solid; BORDER-TOP: #000033 1px solid; BORDER-LEFT: #000033 1px solid; BORDER-BOTTOM: #000033 1px solid; COLOR: #000033; background-color:#ffffff; font-size: 10px; font-family: Verdana,Arial; text-decoration: none'>
        </font></td>
    </tr>
    
<tr> 
      <td width='309' height='50' align='left' valign='top'><font face='verdana,tahoma,arial' color='#000033' size='3'><b><br>
        Zubeh&ouml;r / Sonstiges:</b> </font></td>
      <td width='318' height='100' align='left' valign='middle'> <font size='3'> 
        <textarea rows='5' cols='40' name='input_zubehoer' style='BORDER-RIGHT: #000033 1px solid; BORDER-TOP: #000033 1px solid; BORDER-LEFT: #000033 1px solid; BORDER-BOTTOM: #000033 1px solid; COLOR: #000033; background-color:#ffffff; font-size: 10px; font-family: Verdana,Arial; text-decoration: none'>$zubehoer</textarea>
        </font></td>
    </tr>
    
<tr> 
      <td width='309' height='20' align='left' valign='middle'> 
        <div align='left'><font face='verdana,tahoma,arial' color='#000033' size='3'><b> 
          Eingabezeit:</b></font></div></td>
      <td width='318' height='50' align='left' valign='middle'> <font size='3'> 
        <input type='text' value='$date' name='input_date' size='40' style='BORDER-RIGHT: #000033 1px solid; BORDER-TOP: #000033 1px solid; BORDER-LEFT: #000033 1px solid; BORDER-BOTTOM: #000033 1px solid; COLOR: #000033; background-color:#ffffff; font-size: 10px; font-family: Verdana,Arial; text-decoration: none' value='<? echo '$tage[$tag], $datum'; ?> - <? echo '$time Uhr'; ?>'>
        </font></td>
    </tr>
    
<tr> 
      <td height='30' align='center' valign='bottom' colspan='2'> 
        <div align='center'><br>
          <input type='submit' name='submit' value='Update'>
        </div>
      </td>
    </tr>
  </form>
</table>

          
      ";

    }

    echo "\n        </table><hr>";
    echo "\n        <div align='right'><a href='admin.php?pwd=$pwd'>Admin</a></div>";

    include("db_close.php");
  }
  else{
    echo $login;
  }

  
?>
 
Sorryy

Sorrry leute das euch jetzt so voll gepostet habe, aber hab den Fehler gefunden,

hatte die Tabelle "maschinen" genannt... und hatte sie "maschinendatenbank"

genannt....


Sorry:-)
 
Um antworten zu können musst du eingeloggt sein.

Neue Beiträge

Zurück