doq13207 2016-03-08 08:59
浏览 27
已采纳

注意:未定义的索引:comment_author

I tried many things from StackOverflow regarding this error but with no luck.

I try to show a reply from a comment. The reply comment is shown along with the date and hour when posted but the author who posted the reply is not shown.

The page with error is comments.php on the line $com_name = $row['comment_author'];

The code is:

<?php
    $get_id = $_GET['post_id'];

    $get_com = "select * from comments where post_id='$get_id'";

    $run_com = mysqli_query($con, $get_com);

    while($row=mysqli_fetch_array($run_com)){

        $com = $row['comment'];
        $com_name = $row['comment_author'];
        $date = $row['date'];

        echo "

            <div id='comment'>
            <h3>$com_name</h3><i>Said</i> on $date
            <p>$com</p>
            </div>
        ";
    }
?>

Hope to sort out this error.

Thank you and best regards.

  • 写回答

2条回答 默认 最新

  • dpkt17803 2016-03-08 09:09
    关注

    It looks like there are no column with name comment_author. But there are field user_id. You need to modify you query to below (assume user table users has fields user_name and user_id)

    $get_com = "select c.date, c.comment, u.user_name as comment_author 
        from comments c inner join users u on c.user_id = u.user_id 
        where c.post_id='$get_id'";
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 Spark加载本地pipelinemodel报错
  • ¥20 电脑鼠标键盘不好使了
  • ¥15 求糕手!用matlab求解目标规划模型🙏
  • ¥15 画出的分类图不对,求解答一下
  • ¥20 springboot和springcloud版本问题
  • ¥15 ps2手柄控制树莓派小车
  • ¥30 C#:vsto powerpoint的外接程序
  • ¥30 stata将do文件代码转化为ado文件
  • ¥15 两个同维数组相比,不同位置、出现重复比无意义,而不同位置、不出现重复比,则有意义。把有意义的两个数组放入新的集合MK中。
  • ¥15 写一个可直接调用的函数,将32位有符号数转成另一个无符号的数