使用PHP，mysqli和mysqli_fetch_assoc显示主题列表(Displaying a list of topics with PHP, mysqli and mysqli_fetch_assoc)

 我正在努力建立一个准系统论坛。 我有一个非常简单的数据库叫做talk，有一个叫做main的表，有一个名为title，content和id的列。 $ con是我的连接，我很肯定它有效，因为我用它在我的代码中的其他地方插入数据库。 
 
 我试图显示该表的所有标题，以及该主题页面的链接，基本上为我的论坛制作主题列表。 我没有得到任何东西，而是没有给我一张显示每个标题的表格。 它只是空白。 我上下搜索谷歌和stackoverflow，找到了几个相关的问题，都有完全不同的解决方案，但没有发现任何适合我的东西。 我已经尝试了这段代码的其他一些措辞，但这似乎是我认为最接近工作的代码。 这应该是您需要查看的所有代码，但如果您需要更多信息，请告诉我们。 
 
<?php 
$sql = "SELECT 
            title,
            content,
            id 
            from main
            ORDER BY id DESC;"

if ($result = mysqli_query($con, $sql))
{
echo '<table class="table table-striped">
<tr>
<td>
<h4><strong><center>';

while($row = mysqli_fetch_assoc($result)) {
    echo '<a href="topic.php?id=' . $row['id'] . '">
    ' . $row['title'] . '</a>'

echo '</center></strong></h4>
</td>
</tr>';
}
echo '</table>';
}
?>
 
 感谢您的帮助stackoverflow。 

I am trying to make a barebones forum. I have a very simple database called talk, with a table called main, with columns called title, content, and id. $con is my connection, and I'm positive it works because I use it to insert into the database elsewhere in my code.
 
I am trying to display all the titles of this table, along with a link to that topics page, essentially making a topics list for my forum. Instead of giving me a table that displays each title, I get nothing. It's just blank. I've searched google and stackoverflow up and down, have found several related questions, all with wildly different solutions, but haven't found anything that works for me. I've tried a few other wordings of this code, but this seems to be the code that I think is closest to working. This should be all the code you need to see, but if you need more information, let me know.
 
<?php 
$sql = "SELECT 
            title,
            content,
            id 
            from main
            ORDER BY id DESC;"

if ($result = mysqli_query($con, $sql))
{
echo '<table class="table table-striped">
<tr>
<td>
<h4><strong><center>';

while($row = mysqli_fetch_assoc($result)) {
    echo '<a href="topic.php?id=' . $row['id'] . '">
    ' . $row['title'] . '</a>'

echo '</center></strong></h4>
</td>
</tr>';
}
echo '</table>';
}
?>
 
Thank you for your help stackoverflow.

原文：