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 '
';
//echo "Date after format =";
//echo $year ;
//echo '
';
if ($lastYear !== $year) {
echo '
".$year."
"; echo '".$months[(int) $month]."
"; echo '| Title | Author | Category | Date Submitted | View | |
|---|---|---|---|---|---|
| '.$row['articleTitle'].' | '; echo "".$row['author']." | "; echo "".$row['category']." | "; echo "".$row['date']." | "; echo "".$row['ipAddress']." | "; echo "".$row['status']." | "; echo "
