rendered paste body<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN""http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><html><head><meta http-equiv="content-type" content="text/html; charset=iso-8859-1"/><meta name="description" content="description"/><meta name="keywords" content="keywords"/><meta name="author" content="author"/><link rel="stylesheet" type="text/css" href="default.css" media="screen"/><title>Leeds Media News</title><script type="text/javascript"> function removeText(searchtext) { if(searchtext.value=='Search Articles....')searchtext.value=''; } function addText(searchtext) { if (searchtext.value=='')searchtext.value='Search Articles....'; } </script></head><body><div class="container"> <div class="main"> <div class="header"> <div class="title"> <h1><img src="img/LMNHeader/header.gif" alt="Leeds Media News" width="753" height="124" /></h1> </div> <div id="header-container"> <div class="leftNavCurve"></div> <div id="navcontainer"> <ul id="navlist"> <li><a href="index.php">HOME</a></li> <li><a href="aboutus.php">ABOUT US </a></li> <li><a href="addArticles.php">SUBMIT AN ARTICLE </a></li> <li><a href="contactus.php">CONTACT US </a></li> </ul> <div id="rightNavButtons"> <a href="#"></a> <a href="#"><img src="img/LMNHeader/small-text.gif" alt="" width="16" height="16" /><img src="img/LMNHeader/large-text.gif" alt="" width="23" height="22" /></a> </div> </div> <div class="clear"></div> </div> </div> <div id="topimages"> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="756" height="150"> <param name="movie" value="img/banner2.swf" /> <param name="quality" value="high" /> <embed src="img/banner2.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="756" height="150"></embed> </object> </div> <div class="header2-left"> <h1><?php print date("l F jS, Y, H:i") ?> </h1> </div> <div class="header2-right"> <form action="search.php" method="post"> <input type="text" name="search" id="search" value="Search Articles...." onfocus="removeText(this)" onblur="addText(this)"/> <input name="submit" type="submit" class="button" value="" /> </form> </div> <br/> <div class="content"> <p> <? php>include 'details.php';$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); // select database mysql_select_db($db) or die ("Unable to select database!"); $query = "SELECT *, date_format(timestamp,'%d/%m/%Y') as date FROM `articles` WHERE articles.statusid =4"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());$months = array(01=>'January', 02=>'February', 03=>'March', 04=>'April' , 05=>'May' , 06=>'June', 07=>'July' , 08=>'August', 09=>'September', 10=>'October' , 11=>'November', 12=>'December');if (mysql_num_rows($result) > 0) { while($row = mysql_fetch_assoc($result)) { $date = $row['date']; list($day, $month, $year) = split('[/.-]', $date); //echo "Date from database ="; //echo $row["date"]; //echo '<br>'; //echo "Date after format ="; //echo $year ; //echo '<br>'; if ($lastYear !== $year) { echo '<div class="item">'; echo '<div class="header-container">'; echo '<div class="left-curve"> </div>'; echo '<div class="articleTitle">'; echo "<h1>".$year."</h1>"; echo '</div>'; echo '<div class="right-curve"> </div>'; echo '</div>'; echo '</div>'; echo '<div class="clear">'; echo '</div>'; //$month = ""; } if ($lastMonth !== $month) { echo '<div class="item">'; echo '<div class="header-container">'; echo '<div class="left-curve"> </div>'; echo '<div class="articleTitle">'; echo "<h1>".$months[(int) $month]."</h1>"; echo '</div>'; echo '<div class="right-curve"> </div>'; echo '</div>'; echo '</div>'; echo '<div class="clear">'; echo '</div>'; echo "<table width=\"600px\" >"; echo "<tr align ='left'><th>Title</th><th>Author</th><th>Category</th><th>Date Submitted</th><th>View</th></tr>"; } $lastMonth = $month; $lastYear = $year; echo "<tr>"; echo '<td>'.$row['articleTitle'].'</td>'; echo "<td>".$row['author']."</td>"; echo "<td>".$row['category']."</td>"; echo "<td>".$row['date']."</td>"; echo "<td>".$row['ipAddress']."</td>"; echo "<td>".$row['status']."</td>"; echo "</tr>"; echo "</table>"; } }else echo 'No articles have been selected for viewing'; // free result set memory mysql_free_result($result); // close connection mysql_close($connection); ?> </p> </div> <div class="sidenavContainer"> <div class="sideNavList"> <ul> <li id="newMedia"><a href="newMedia.php" title="New Media">New Media </a></li> <li id="webDesign"><a href="webdesign.php" title="Web Design & Development">Web Design & Development</a></li> <li id="internetMarketing"><a href="internetmarketing.php" title="Internet Marketing">Internet Marketing</a></li> <li id="traditionalMarketing"><a href="traditionalmarketing.php" title="Traditional Marketing">Traditional Marketing</a></li> </ul> <br /> <center> <img src="img/LMNLeftNav/divider.gif" alt="divider" /> </center> <br /> <ul> <li id="events"><a href="events.php" title="Events">Events</a></li> </ul> <center><img src="img/LMNLeftNav/small calander.jpg" alt="events" /></center> <ul> <li id="appointments"><a href="appointments.php" title="Appointments">Appointments</a></li> </ul> <center><img src="img/LMNLeftNav/shake...jpg" alt="boo" /></center> <ul> <li id="jobs"><a href="jobs.php" title="Jobs">Jobs</a></li> </ul> </div> <br /> <center> </center> </div> <div class="clearer"><span></span></div> </div> <div class="footer-container"> <div class="leftNavCurve"> </div> <div class="footer">© 2007 <a href="index.html">Leedsmedianews.co.uk</a>. Valid <a href="http://jigsaw.w3.org/css-validator/check/referer">CSS</a> & <a href="http://validator.w3.org/check?uri=referer">XHTML</a></div> <div class="rightNavCurve"> </div> </div></div></body></html>