en lille en
okay jeg tager en udtræk ud af DB til denne side<table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" background="gfx/middle_2.jpg" class="overskrift">Nyhederne</td>
</tr>
</table>
<br>
<?
$result = mysql_query("select * from games4gamers_news order by ID desc");
while ($row = mysql_fetch_array($result))
{
extract($row);
$nyhed = stripslashes($nyhed);
$nyhed = nl2br($nyhed);
$query_antal = mysql_query("SELECT count(*) AS Amount FROM games4gamers_comment WHERE nyhedid = '$ID'");
list($antal) = mysql_fetch_row($query_antal);
echo "<table width='99%' border='0' cellspacing='0' cellpadding='0'>";
echo "<tr>";
echo "<td colspan='2' background='gfx/middle_2.jpg' class='overskrift' height='16' align=center>$headline</td>";
echo "</tr><tr>";
echo "<td width='95%' valign=top bgcolor='#F0F3EA' class='cellnotandb'>";
echo "$nyhed";
echo "</td>";
echo "<td width='150' bgcolor='#F0F3EA' align=right valign=top>";
echo "<img src='nyhedimg/g4g.jpg' width='130' height='90'>";
echo "</td></tr><tr>";
echo "<td colspan='2' background='gfx/middle_2.jpg' height='16' align=center>";
echo "Posted af <a href='mailto:$email'>$bruger</a> | $dato | <A href='index.php?mode=comment&newsid=$ID'>Kommentarer</a> (<A href='index.php?mode=comment&newsid=$ID'>0</a>)";
echo "</td></tr></table>";
}
?>
datoen i db (mysql) er sådan her 2002-08-27 19:28:15
skulle gerne være 27/08-02 19:28:15
hvordan fikser jeg det ????? goe points at hente til første "svar" der virker :)
