Stuff

<?php
include 'library/config.php';
include 'library/opendb.php';

// if no id is specified, list the available articles
if(!isset($_GET['id']))
{
    $self   = $_SERVER['PHP_SELF'];

    $query  = "SELECT id, title FROM news ORDER BY id";
    $result = mysql_query($query) or die('Error : ' . mysql_error()); 
    
    // create the article list 
    $content =  '<ol>';
    while($row = mysql_fetch_array($result, MYSQL_NUM))
    {
        list($id, $title) = $row;
        $content .= "<li><a href=\"$self?id=$id\">$title</a></li>\r\n";
    }
    
    $content .= '</ol>';
    
    $title   = 'Available Articles';
} else {
    // get the article info from database
    $query   = "SELECT title, content, time FROM news WHERE id='" . mysql_real_escape_string($_GET['id']) . "' LIMIT 1";
    $result  = mysql_query($query) or die('Error : ' . mysql_error()); 
    $row     = mysql_fetch_array($result, MYSQL_ASSOC); 
    
    $title   = $row['title'];
    $content = $row['content'];
    $time    = $row['time'];
}    

include 'library/closedb.php';
?>
<html>
<head>
<title>
<?php echo $title;?>
<body>
<table width="600" border="0" align="center" cellpadding="10" cellspacing="1" bgcolor="#336699">
 <tr> 
  <td bgcolor="#FFFFFF">
<h1 align="center"><?php echo $title;?></h1>
<?php 
<form method="post">
  <table width="700" border="0" cellpadding="2" cellspacing="1" class="box" align="center">
    <tr> 
      <td width="100">Title</td>
      <td><input name="title" type="text" class="box" id="title"></td>
    </tr>
    <tr> 
      <td width="200">Content</td>
      <td><textarea name="content" cols="50" rows="10" class="box" id="content"></textarea></td>
    </tr>
    <tr> 
      <td width="200">&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr> 
      <td colspan="2" align="center"><input name="save" type="submit" class="box" id="save" value="Save Article"></td>
    </tr>
  </table>
</form>
</body>


// when displaying an article show a link
// to see the article list
if(isset($_GET['id']))
{ 
?>
   <p>&nbsp;</p>
   <p align="center"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">Article List</a></p>
<?php echo $time;
}
?>  
  </td>
 </tr>
</table>
</body>
</html>