1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | 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 5Debug 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | <?php# Copyright by Manuel# Support www.ilch.de# modifiziert von C.C.A.A Support www.dragondesigns.dedefined ('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
