Post a comment...
$dbh=mysql_connect ("localhost", "leonstem_leonuse", "head1ache") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("leonstem_leon");
if ($addthispage == "all" or $addthispage == "") {
$query="SELECT * FROM comments ORDER BY id DESC";
} else {
$query="SELECT * FROM comments where page='$addthispage' ORDER BY id DESC";
}
$result=mysql_query($query);
mysql_close();
$num=mysql_numrows($result);
if ($num == 0) {
echo "Nobody has left a message yet.";
}
$i=0;
while ($i < $num) {
$poster=mysql_result($result,$i,"poster");
$comment=mysql_result($result,$i,"comment");
$date=mysql_result($result,$i,"date");
$page=mysql_result($result,$i,"page");
// transform the date
$dateinnumbers = strtotime("$date");
$dateinletters = date("m-d-y", $dateinnumbers);
echo "