jeg har retter op med din kode,men ny problem med line 30
line 30:
$topic_title =
stripslashes(topic_info['topic_title']);
while ($topic_info =
mysql_fetch_array($get_topics_res)) {
$topic_id = $topic_info['topic_id'];
$topic_title =
stripslashes(topic_info['topic_title']);
$topic_create_time =
$topic_info['fmt_topic_create_time'];
$topic_owner =
stripslashes($topic_info['topic_owner']);
fuld kode:
<?php
// skab forbindelse til server og vælge database
$conn = mysql_connect("localhost", "*****", "*****") or die(mysql_error());
mysql_select_db("forum",$conn) or die(mysql_error());
// hent emnerne
$get_topics = "select topic_id, topic_title, date_format(topic_create_time, topic_owner from forum_topics order by topic_create_time decs";
$get_topics_res = mysql_query($get_topics,$conn) or die(mysql_error());
if (mysql_num_rows($get_topics_res) < 1) {
// er det ingen emner, så fortæl det
$display_block = "<p><em>No topics exist.</em></p>";
} else {
// opret streng til udskriften
$display_block = "
<table cellpadding=\"3\" cellspacing=\"1\" border=\"1\">
<tr>
<th>TOPIC TITLE</th>
<th># of POSTS</th>
</tr>";
while ($topic_info =
mysql_fetch_array($get_topics_res)) {
$topic_id = $topic_info['topic_id'];
$topic_title =
stripslashes(topic_info['topic_title']);
$topic_create_time =
$topic_info['fmt_topic_create_time'];
$topic_owner =
stripslashes($topic_info['topic_owner']);
// hent antal indlæg
$get_num_posts = "select count(post_id) from forum_post where topic_id = $topic_id";
$get_num_post_res = mysql_query($get_num_posts,$conn) or die(mysql_error());
$num_post = mysql_rsultat($get_num_posts_res,0,'count(post_id)');
// føj til udskriften
$display_block = ."
<tr>
<td><a href=\"showtopic.php?topic_id=$topic_id\"><strong>$topic_title</strong></a><br>
create on $topic_create_time by $topic_owner</td>
<td align="center">$num_posts</td>
</tr>";
}
// afslut tabel
$display_block .= "</table>";
}
?>
<html>
<head>
<title>Topics in my forum</title>
</head>
<body>
<h1>Topic in my forum</h1>
<?php print you like to <a href="addtopic.thml">add a topic </a>?</p>
</body>
