Ok below is my display script, though I have no idea how to make an edit script so could someone either make one for me or if thats too much to ask atleast help me make one.
<?
$username="";
$password="";
$database="";
$con = mysql_connect('localhost',$username,$password) or die('Error: ' . mysql_error());
mysql_select_db($database) or die('Error: ' . mysql_error());
$colNum = 1;
$sql = "SELECT * FROM `blog` ORDER BY `id` DESC LIMIT 0, 3";
$query = mysql_query($sql,$con) or die('Error: ' . mysql_error());
$table = '<table border="0" width="100%" cellpadding="0" cellspacing="5">';
$table .= '<tr>';
$num = 1;
while ($r = mysql_fetch_array($query)) {
$id=$r['id'];
$author=$r['author'];
$content=$r['content'];
$today=$r['today'];
$table .=<<<HTML
<td>
<table border=1 width=100% cellpadding=2 cellspacing=0>
<tr width=100%>
<td width=100% bgcolor=000013>
<center><b><FONT COLOR=BBFFFF><FONT FACE=Verdana,Arial,Times New I2><FONT SIZE=2>$today:</font></font></font></b><br /><B><FONT COLOR=BBFFFF><FONT FACE=Verdana,Arial,Times New I2><FONT SIZE=1>Written by: $author</font></font></font></b></center>
<p align=left><FONT FACE=Verdana,Arial,Times New I2><FONT SIZE=2><FONT COLOR=BBFFFF>$content</p>
</td>
</tr>
</table>
</td>
HTML;
if ($num == $colNum) {
$table .= '</tr><tr>';
$num = 0;
}
$num++;
}
$table .= '</table>';
echo $table;
mysql_close($con);
?>
