schooner :: inlägg";
$prefix = "../";
$template = 3;
include("$prefix" . "whp_header.inc");
?>
Could not connect to database serverCheck passwords and sockets
");
// select the database
mysql_select_db("$database",$db)
or die("Could not select database $database
Check database name
");
// ---------------------------
// post
// ---------------------------
// select post
$result = mysql_query("select *
from $database_table
where id = '$the_id'
order by year, month, day
limit $front_page_max",$db)
or die("Could not select posts
");
// output post
echo("\n\n");
while($row = mysql_fetch_array($result)) {
$the_id = $row["id"];
$the_day = $row["day"];
$the_month = $row["month"];
$the_date = $row["date"];
$the_year = $row["year"];
$the_category = $row["category"];
// parse out the category id into its string value
$result2 = mysql_query("select *
from $database_table_categories
where id = '$the_category'",$db)
or die("Could not select category
");
while($row2 = mysql_fetch_array($result2)) {
$the_category_name = $row2["category"];
}
$the_showpref = $row["showpref"];
$the_title = $row["title"];
$the_body = $row["body"];
echo("\n\n");
}
// ---------------------------
// comments
// ---------------------------
// set vars to null
$comment_month = "";
$comment_date = "";
$comment_year = "";
$comment_title = "";
$comment_body = "";
$comment_author_name = "";
$comment_author_email = "";
$comment_author_url = "";
$the_post_id = "";
// select comments for this post
$result_comments = mysql_query("select *
from $database_table_comments
where post_id = '$the_id'
order by comment_year, comment_month, comment_date",$db)
or die("");
// print a comments header
echo(
""
);
while($row = mysql_fetch_array($result_comments)) {
$comment_month = $row["comment_month"];
$comment_date = $row["comment_date"];
$comment_year = $row["comment_year"];
$comment_body = $row["comment_body"];
$comment_author_name = $row["comment_author_name"];
$comment_author_email = $row["comment_author_email"];
$comment_author_url = $row["comment_author_url"];
// print comments
echo("\n\n"
);
// or print some feedback NOT WORKING!!!
//if ($row == "") {
// echo("There are no comments on this post
\n");
//}
}
echo("\n\n");
// new comment form
echo(" " .
"\n" .
"
\n\n"
);
?>