Miscellany
public text v1 · immutable<?php
function getPosts(){
include ('db.php');
$query = "SELECT id, title, entry, DATE_FORMAT(date, '%M %d, %Y') as entrydate FROM root_blog";
$result = mysql_query($query);
if ($result) {
while ($data = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo $data['title'];
echo $data['entry'];
echo $data['entrydate'];
}
} else {
echo 'Unable to retrieve entries from database.';
}
}
getPosts();
?>