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
