Darxus' Adventures
Newer entries found here.
$db = mysql_connect("localhost","root","mysqlf00") or die("Could not connect to db.");
if (mysql_select_db("adventures",$db))
{
// print("Database opened successfully.
\n");
} else {
printf("Error opening database: %s.
\n", mysql_error());
}
//print "$GLOBALS[REQUEST_URI]
\n";
if($order == 'asc')
{
$sort = 'ASC';
print "Order:
Ascending /
Descending\n";
} else {
$sort = 'DESC';
print "Order:
Ascending /
Descending\n";
}
$result = mysql_query("SELECT * FROM entries ORDER BY date $sort",$db);
if($myrow = mysql_fetch_array($result))
{
print "
\n";
do
{
$myrow[num] = sprintf ("%02d", $myrow[num]);
echo("| $myrow[date] | $myrow[title] |
\n");
} while($myrow = mysql_fetch_array($result));
echo("
\n");
} else {
printf("No records found: %s.
\n", mysql_error());
}
?>
Comment on this page.
Return to Darxus' home page.
Valid HTML 3.2.