require("../ADMIN/connect_db.inc");
//$query = "SELECT * FROM w3cpress ORDER BY yyyymmdd desc";
$query = "SELECT * FROM w3cpress WHERE substr(yyyymmdd,1,4)='".$year."' ORDER BY yyyymmdd desc";
$result = mysql_query($query, $link);
while ($row = mysql_fetch_array ($result)) { ?>
=$row['title']?>
echo $row['date'] . " ". substr($row['yyyymmdd'],0,4); ?>
}
mysql_close($link); ?>