Diskussionsforum - hjælp mig
Den siger dette: "Der er en fejl i SQL syntaksen nær '(post_id) from forum_posts where topic_id =1' på linje 1"... fatter det simpelthen ikke...Her er min kode som der er fejl i....
hvor er fejlen?
<?php
$conn = mysql_connect("XXX", "XXX", "XXX")
or die(mysql_error());
mysql_select_db("viola",$conn) or die(mysql_error());
$get_topics = "select topic_id, topic_title, date_format(topic_create_time, '%b %e %Y %r') as fmt_topic_create_time,
topic_owner from forum_topics order by topic_create_time desc";
$get_topics_res = mysql_query($get_topics,$conn) or die(mysql_error());
if (mysql_num_rows ($get_topics_res) < 1) {
$display_block = "<P><em>Der er ingen topics.</em></p>";
}else{
$display_block = "
<table cellpadding=3 cellspacing=1 border=1>
<tr>
<th>Topic titel</th>
<th># of posts</th>
</tr>";
//20
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']);
//30
$get_num_posts = "select count (post_id) from forum_posts where topic_id =$topic_id";
$get_num_posts_res =
mysql_query($get_num_posts,$conn)
or die(mysql_error());
$num_posts = mysql_result($get_num_posts_res,0, 'count(post_id)');
$display_block .= "
<tr>
<td><a href=\"showtopic.php?topic_id=$topic_id\">
<strong>$topic_title</strong></a><br>
Created on $topic_create_time by $topic_owner</td>
<td align=center>$num_posts</td>
</tr>";
}
$display_block .= "</table>";
}
?>
<html>
<head> <title>Topics i forum</title>
</head>
<body>
<h1>Topics</h1>
<?php print $display_block; ?>
Vil du gerne <a href="AddTopic.html">lol</a>?
</body></html>
