$query=”SELECT * FROM press_releases ORDER BY pr_date DESC”;
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,”pr_id”);
$date=mysql_result($result,$i,”pr_date”);
$title=mysql_result ($result,$i,”title”);
$pdf=mysql_result ($result,$i,”pdf”);
$date = date(“F d, Y”, strtotime($date));
echo ”
- “;
- echo ”
- $date
“;
echo ”
“;
echo ”
“;
$i++;
}
?>