Miscellany

				    $query0 = mysql_query("SELECT title, id FROM main ORDER BY date"); 
          	    while(($oPast = mysql_fetch_assoc($query0)) !== false){
          	    					 $id2 = $oPast['id'];
          	    					 $title = $oPast['title']; ?>
          	    <a href="admin.php?edit=pastEntries&id=<?=$id2?>"><?=$title?></a>
          	    <?php 			 }
		          					 $id = (int)$_GET['id'];
          	    $query1 = mysql_query("SELECT content, title, date, id FROM main WHERE id=$id"); 
          	    while(($oBlog = mysql_fetch_assoc($query1)) !== false){
          	    		          $oContent = $oBlog['content'];
  										 $oTitle = $oBlog['title'];
          	   					 $oDate = $oBlog['date'];
          	    							if(!$oContent){
          	    									$oContent = post_addslashes('content');}
          	    							if(!$oTitle){
          	    									$oTitle = post_addslashes('title');}
          		 ?>     								

	<p>Posted date : <?=$oDate?></p>

	<form action="<?=$PHP_SELF?>" method="POST">
		<textarea name="title" rows="1" cols="63"><?=$oTitle?></textarea><br />
		<textarea name="content" rows="20" cols="63"><?=$oContent?></textarea><br />

			<input type="submit" name="submit" value="Submit" />
	</form>


				<?php
					if(!empty($_POST['submit'])){

					$query2 = "UPDATE main SET content = '$oContent', title = '$oTitle' WHERE id = '$id'";
 					mysql_query($query2);
 							}  
						}
					mysql_close();
					}