I rewrote my blog script to use mysql because it seems to work better then using text files... I have every thing working fine, except I dont know how to display the results in reverse chronoligical order... here is the code used to display the blog:
mysql_connect ($dbhost, $dbusername, $dbpassword); //connect
mysql_select_db ($dbname); //select the db
$result = mysql_query("SELECT * FROM blog
WHERE name LIKE '%'
AND date LIKE '%'
AND message LIKE '%'
"); //get the messages and names and dates
include($header);
if($author == "1"){
echo "<a href=\"blog2.php?post\">Write a post to the blog</a> - <a href=\"blog2.php?deleteall\">Clear all blog entrys</a>\r\n<br />";
}
if ($row = mysql_fetch_array($result)){
do {
$date = date("F j, Y, g:i:s a", $row["date"]);
$name = $row["name"];
$message = $row["message"];
$message = nl2br($message);
$message = str_replace('[url=', '<a target="_blank" href="', $message);
$message = str_replace('[end]', '">', $message);
$message = str_replace('[/end]', '">', $message);
$message = str_replace('[/url]', '</a>', $message);
$message = strip_tags($message, '<a><br><u><i><hr><p><ul><li><ol>');
print "<table width=\"75%\" border=\"0\" bgcolor=\"#E5E5E5\">
<tr>
<td>Name: ".$name."</td>
<td>
<div align=\"right\">".$date."</div>
</td>
</tr>
<tr>
<td colspan=\"2\"><hr />".$message."<hr /></td>
</tr>
<br />";
} while($row = mysql_fetch_array($result));
} else {
print "Sorry, blog posts are in the db right now!";
}
mysql_close();
thank you if you can provide any help
