rendered paste body<?php require_once('../dbconnect.php'); $query = 'SELECT * FROM clan_news ORDER BY date_entered DESC'; if ($r = mysql_query ($query) ) { if (mysql_num_rows() > 0){ if ( $_SESSION['level_id'] < 2) { print ''; } else { print '<div align="right"><a href="index.php?page=admin+post">Create New Post</a></div>'; } } if ( $_SESSION['level_id'] < 2) { while ($row = mysql_fetch_array ($r)) { print '<table width="564" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="24" background="images/Decline_25.jpg"><table width="543" border="0" align="right" cellpadding="0" cellspacing="0"> <tr> <td width="334"><span class="newstitle">'. $row['title'] .'</span></td> <td width="111"><span class="Postedby">Posted by:</span><span class="style3">'. $row['author'] .'</a></strong></span></td> <td width="98"><span class="Postedby">Date:</span> <span class="postedname">'. $row['date_entered'] .'</span></td> </tr> </table></td> </tr> <tr> <td background="images/Decline_23.jpg"><table width="543" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><span class="infostats">'. $row['entry'] .'</span></td> </tr> </table></td> </tr> <tr> <td><img src="images/Decline_24.jpg" width="564" height="7" /></td> </tr> </table> <br /><br /><hr align="left" color="grey" size="1px thin" style="width:200px;" />"; '; } } else { while ($row = mysql_fetch_array ($r)) { print "<p><h2>{$row['title']}</h2> {$row['entry']}<br /><br /><a href=\"blog/edit_post.php?id={$row['blog_id']}\">Edit</a> <a href=\"blog/delete_post.php?id={$row['blog_id']}\">Delete</a> </p><hr align=\"left\" color=\"grey\" size=\"1px thin\"style=\"width:200px;\" />\n"; } } } else { die(mysql_error()); } mysql_close(); ?>