Location: PHPKode > scripts > News Script > news-script/admin/manageNews.php
<?php
/**
 * manageNews.php
 * 
 * Displays all news items with an option to delete or edit each article
 */
require('../config.php');

$connection = mysql_connect($db_host, $db_user, $db_password) 
				or die("Unable to connect to MySQL");
							
mysql_select_db($db_name, $connection) or die("Unable to select DB!");

/**
 * show all atricles with options to edit/delete
 */
// Use the limit in our settings to decide how many to show
$result = mysql_query("SELECT * FROM newstbl ORDER BY date DESC LIMIT 0, $lim");
		
/* While we have more rows display them */
while($row = mysql_fetch_assoc($result))
{
	// Display the row
	$id = $row['id'];
	$author =  $row['author'];
	$content = $row['content'];
	
	/**
	 * show each article with edit/delete links
	 */
	echo "<div>ID: $id</div>";
	echo "<div>Author: $author</div>";
	echo "<div>Content: $content</div>";
	echo "<div><a href=\"editNewsForm.php?id=$id\">Edit</a> | <a href=\"deleteNews.php?id=$id\">Delete</a></div>";
	echo"<br /><hr />";
			
}


mysql_close($connection);
?>
Return current item: News Script