All pastes #382856 Raw Edit

Untitled

public php v1 · immutable
·published 2007-03-05 23:22 UTC
rendered paste body
$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		  AND articles.articleID		  LIMIT 0 , 5";		  $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());if (mysql_num_rows($result) > 0) { 	while($row = mysql_fetch_assoc($result)) { 	$date = $row['date'];	list($month, $day, $year) = split('[/.-]', $date);					echo "Date from database =";		echo $row["date"];		echo '<br>';		echo "Date after format =";		echo $date;		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>".$date."</h1>";		echo '</div>';		echo '<div class="right-curve"> </div>';		echo '</div>';		echo '</div>';		echo '<div class="clear">';		echo '</div>';		}	$lastYear = $date;	}	}else	echo 'No articles have been selected for viewing';	// free result set memory mysql_free_result($result); // close connection mysql_close($connection); ?>