"; echo ""; if (isset($idd)) $getfirst = mysql_query("SELECT * FROM sitenews WHERE id=$idd"); else $getfirst = mysql_query("SELECT * FROM sitenews ORDER BY date DESC LIMIT 1"); while ($row = mysql_fetch_array($getfirst)) { $dateuploaded = dateStringToUnixTimestamp($row[date]); $dateuploaded = date("d/m/Y", $dateuploaded); echo ""; echo ""; } echo "
$dateuploaded -$row[title]
$row[content]


"; echo "
Previous news articles:
"; $getnews = mysql_query("SELECT * FROM sitenews ORDER BY date DESC"); $i = 1; while ($row = mysql_fetch_array($getnews)) { if(($i % 2) == 1) $rowcolor = $contrasting_bgcolor_1; else $rowcolor = $contrasting_bgcolor_2; $dateuploaded = dateStringToUnixTimestamp($row[date]); $dateuploaded = date("d/m/Y", $dateuploaded); echo ""; echo ""; echo "
$dateuploaded$row[title]more
"; $i++; } echo "
"; echo "

"; ?>