All pastes #76866 Raw Edit

Miscellany

public php v1 · immutable
·published 2006-07-02 05:38 UTC
rendered paste body
				    $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();					}