list.php

14-4 list.php

<?php
include "setup.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title></title>

<link rel="stylesheet" type="text/css" href="dhtmlxSuite/dhtmlxMenu/codebase/skins/dhtmlxmenu_dhx_skyblue.css">
<script src="dhtmlxSuite/dhtmlxMenu/codebase/dhtmlxcommon.js"></script>
<script src="dhtmlxSuite/dhtmlxMenu/codebase/dhtmlxmenu.js"></script>

    <style>
        html, body {
            width: 100%;
            height: 100%;
            margin: 0px;
            padding: 0px;
            overflow: hidden;
        }
    </style>

<script>
    var menu;
    function initMenu() {
        menu = new dhtmlXMenuObject("menuObj");
        menu.setIconsPath("icons/");
        menu.loadXML("menu.xml");
    }
</script>

</head>
<body onload="initMenu();">
<div id="menuObj"></div>

<?php
$sql = "select * from note order by post_date desc";
$result=mysql_query($sql);
echo "<div style='font-size:11px;padding:4px;'>";
while(list($sn,$title,$content,$post_date)=mysql_fetch_row($result)){
    echo "<li><a href='view.php?sn=$sn'>$title</a></li>";
}
echo "</div>";

?>

</body>
</html>