Hallo Vinzenz
Danke für deine prompte Antwort...
Hier ein Teil meines Codes....
<?php
include("admin/zugang.inc.php");
switch ($jahr)
{
case "1992" : $sql="SELECT * FROM top100, woche WHERE top100.jahr='$jahr' AND woche.jahr='$jahr' AND top100.kw='$kw' and woche.kw='$kw' LIMIT 0,1";
break;
case "1993" : $sql="SELECT * FROM top100, woche WHERE top100.jahr='$jahr' AND woche.jahr='$jahr' AND top100.kw='$kw' and woche.kw='$kw' LIMIT 0,1";
break;
default : $sql="SELECT * FROM nodata";
break;
}
$ergebnis = mysql_query($sql,$verbindung);
echo "<table width='471' border='1' bordercolor='#FF9900' cellspacing='1'cellpadding='1' align='center'>";
echo "<tr bgcolor='#FFAC05'>";
echo "<td align='center'><font color='#000000'><FONT FACE='Arial' SIZE=2><b>Charts Fuer Die Woche Vom</td>";
echo "</tr>";
while ($row = mysql_fetch_object($ergebnis))
{
echo "<tr bgcolor='#000080'>
<td align='center'><font color='#FFFF00'><b>$row->datum</b></td>
</tr>";
}
echo "</table>";
echo "<p>";
mysql_free_result($ergebnis);
mysql_close($verbindung);
?>
<?php
$db = @MYSQL_CONNECT($server,$benutzer,$kennwort); mysql_select_db("top100",$db);
//$bioId = mysql_escape_string($bioId);
$result = mysql_query("SELECT top100.*,(SELECT count(*) from top100 as top100 WHERE top100.interpret= top100.interpret AND top100.titel= top100.titel) AS ANZAHL FROM top100, woche WHERE top100.jahr='$jahr' AND woche.jahr='$jahr' and top100.KW='$kw' AND woche.kw='$kw' ORDER BY 'Platz' LIMIT $pos");
while ($row = mysql_fetch_row ($result))
{
if ($row[19] == '<img border="0" src="images/single/new.gif" width="53" height="16">')
$change = '<font color="#FF0000">Neu';
else if ($row[19] == '<body bgcolor="#FF0000"><font size ="1" color="#000000">Wiedereinsteiger</font></p>')
$change = '<img border="0" src="images/single/point.gif" width="12" height="10">';
else if ($row[6] == $row[19])
$change = '<img border="0" src="images/single/point.gif" width="12" height="10">';
else if ($row[6] < $row[19])
$change = '<img border="0" src="images/single/a_up.gif" width="12" height="10">';
else if ($row[6] > $row[19])
$change = '<img border="0" src="images/single/a_down.gif" width="12" height="10">';
echo"<center>";
echo"<table border='1' width='49%' height='35' bgcolor='#000080' border='2' bordercolor='#FFAC05'>";
echo" <tr>";
echo" <td width='9%' height='1' rowspan='3' align='center' border='2' bordercolor='#FFAC05'>";
echo" <p align='center'border='2' bordercolor='#FFAC05'><font color='#FFAC05'><i><b><FONT FACE='Arial' SIZE='2'>$row[6]</p>";
echo" </td>";
echo"<td width='9%' height='33' align='center'><font color='#FFFFFF'><i><b><FONT FACE='Arial' SIZE='2'><i><b><FONT FACE='Arial' SIZE='2'>$change</td>";
echo"<td width='62%' height='1' rowspan='2' align='center' colspan='4'>";
echo"<p align='center'><font color='#FFFFFF'><i><b><FONT FACE='Franklin Gothic Medium' SIZE='3'>$row[1]</p>";
echo" </td>";
echo"<td width='20%' height='29' rowspan='4' align='center'><font color='#FFFFFF'><i><b><FONT FACE='Arial' SIZE='2'><i><b><FONT FACE='Arial' SIZE='2'>$row[8]</td>";
echo" </tr>";
echo"<tr>";
echo" <td width='9%' height='1' rowspan='2' align='center'><font color='#FFAC05'><i><b><FONT FACE='Arial' SIZE='2'>$row[19]</td>";
echo"</tr>";
echo"<tr>";
echo"<td width='62%' height='29' align='center' colspan='4'>";
echo" <p align='center'><font color='#FFFF00'><i><b><FONT FACE='Arial' SIZE='2'>$row[2]</td>";
echo" </tr>";
echo" <tr>";
echo"<td width='18%' height='32' colspan='2' align='center'><font color='#FFAC05'><i><b><FONT FACE='Arial' SIZE='2'>KW $kw</td>";
echo"<td width='11%' height='16' align='center'><a href='biografien.php?bioId=$row[1]'><img border='0' src='images/biografie.gif' width='65' height='15'></td>";
echo"<td width='1%' height='16' align='center'>$row[9]</td>";
echo" <td width='9%' height='16' align='center'>$row[14]</td>";
echo" <td width='10%' height='16' align='center'><font color='#FFAC05'><i><b><FONT FACE='Arial' SIZE='2'>$row[21]</td>";
echo" </tr>";
echo"</table>";
echo" </center>";
echo" </div>";
echo"<p>";
echo mysql_error();
?>
Den Code hab ich mal vor cirka 5 Jahren geschrieben.