All pastes #382919 Raw Edit

Miscellany

public php v1 · immutable
·published 2007-03-06 00:23 UTC
rendered paste body
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 "</table>"; 	 	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>';				}		if ($lastMonth !== $month) { 		echo "</table>"; 	 	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 $row["articleTitle"];	echo '<br>';	echo $row["date"];	}	}else	echo 'No articles have been selected for viewing';	// free result set memory mysql_free_result($result); // close connection mysql_close($connection); ?>