» Forum » Clanscript » Fehlersuche und Probleme » Lastwar
  Mitglieder   |   Gallery   |   FAQ's   |   Regeln

[ Anmelden zum schreiben ]

Lastwar
CC I Warfighter
Mitglied
0 Beitragspunkte
Posts: 178

User Pic

0 Mitglieder finden den Beitrag gut.

Merkliste 26.07.2009 - 19:20:33     Zitieren
Hallo alle zusammen bei mir kommt dieser Fehler

MySQL Error:
1054 : Unknown column 'gegner' in 'field list'
in Query:
SELECT DATE_FORMAT(datime,"%d.%m.%y - %H:%i") as datum,tag, owp, opp, gegner, id, game, wlp FROM ic1_wars WHERE status = "3" ORDER BY datime DESC LIMIT 5
Debug backtrace:
	@ mysql.php:32 -- debug_bt()
	@ mysql.php:50 -- db_check_error(...)
	@ lastwars.php:12 -- db_query(...)
	@ design.php:330 -- require_once(...)
	@ design.php:172 -- design->get_boxcontent(...)
	@ design.php:69 -- design->replace_boxes(...)
	@ news.php:9 -- design->design(...)
	@ news.php:21 -- require_once(...)
	@ index.php:27 -- require_once(...)

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/dynastygaming.de/httpdocs/include/includes/func/db/mysql.php on line 67


Ich benutze diesen Code


<?php
#   Copyright by Manuel
#   Support www.ilch.de
#   modifiziert von C.C.A.A Support www.dragondesigns.de

defined ('main') or die ( 'no direct access' );

$farbe = '';
$farb2 = '';

echo '<table width="100%" border="0" cellpadding="2" cellspacing="0">';
$erg = db_query('SELECT DATE_FORMAT(datime,"%d.%m.%y - %H:%i") as datum,tag, owp, opp, gegner, id, game, wlp FROM prefix_wars WHERE status = "3" ORDER BY datime DESC LIMIT 5');
while ($row = db_fetch_object($erg) ) {
    $row->tag = ( empty($row->tag) ? $row->gegner : $row->tag );

  if ($row->wlp == 1) {
    $bild = 'include/images/icons/win.gif';

  } elseif ($row->wlp == 2) {
    $bild = 'include/images/icons/los.gif';

  } elseif ($row->wlp == 3) {
    $bild = 'include/images/icons/pad.gif';

  }

     
    echo '<tr><td>'.get_wargameimg($row->game).'</td><td align="left">';
    echo '<a class="lastbox" href="index.php?wars-more-'.$row->id.'">';
    echo  $row->datum.' <br><span class="smalfont"> '.$row->owp.' '.$lang['at2'].' '.$row->opp.'</span> - '.$row->tag.'</a></td><td><img src="'.$bild.'"></td></tr>';

}
echo '</table>';
?>



verwendete ilchClan Version: 1.1

betroffene Homepage: dynastygaming.de


http://www.dynastygaming.de/include/images/linkus/linkusbanner.jpg

[ Anmelden zum schreiben ]