Code: Select all
<?php
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM `Posts` ORDER BY `Date` DESC LIMIT 10";;
$result=mysql_query($query);
mysql_close();
?>Code: Select all
<?php
$Title=mysql_result($result,$i,"Title");
$Body=mysql_result($result,$i,"Body");
$Date=mysql_result($result,$i,"Date");
$Author=mysql_result($result,$i,"Author");
echo "<center><h1>$Title</h1></center><br/><table><tr><td>
<p>$Body</p></td></tr></table><br><h6 align='right'>By: $Author<br>Date:$Date</h6><hr>";
$i--;
?>