";
PRINT "";
PRINT "Pauls Graffiti";
PRINT "";
PRINT '';
PRINT "";
PRINT "Wrighton's Graffiti
";
PRINT 'Messages from the public
';
PRINT "";
PRINT '
';
print '
';
print ' ';
print ' ';
print ' ';
print '';
print ' ';
print ' | ';
print '";
PRINT " ";
PRINT 'Most recent entries will be first.';
print ' | ';
print '
';
print ' ';
print '
';
include("dbup.php");
$result = mysql_query( "SELECT DATE_FORMAT(entered, '%d-%m-%Y') AS entered, heading, contents FROM journal
ORDER BY id DESC",$db)
or die("Query failed with error ".mysql_error());
$xml_output = "\n";
$xml_output .= "\n";
for($x = 0 ; $x < mysql_num_rows($result) ; $x++){
$row = mysql_fetch_assoc($result);
$xml_output .= "\t\n";
$xml_output .= "\t\t" . $row['entered'] . "\n";
$xml_output .= "\t\t - " . $row['heading'] . "
\n";
// Escaping illegal characters
$row['contents'] = str_replace("&", "&", $row['contents']);
$row['contents'] = str_replace("<", "<", $row['contents']);
$row['contents'] = str_replace(">", ">", $row['contents']);
$row['contents'] = str_replace("\"", """, $row['contents']);
$row['contents'] = nl2br($row['contents']);
$xml_output .= "\t\t" . $row['contents'] . "\n";
$xml_output .= "\t
\n";
}
$xml_output .= "";
echo $xml_output;
PRINT "";
PRINT 'Thank you for reading or scribbling!
';
PRINT '
';
PRINT "";
PRINT "