mysql - 如何在mysqli_fetch_assoc的while循环内仅打印所需的结果？

Question

如标题中所述，我只想打印付款大于10的那些条目的结果，否则它将回显错误消息。在这里，我的代码可以打印结果，但也可以打印错误消息和结果。这对我来说很难解决该问题。我是新手，需要您的帮助。提前致谢

 <?php                              

            if(isset($_GET['l']))
                         {  
                            $user=$_SESSION['username'];
                            $qry1="SELECT * from entry where username='$user'";
                            $result1=mysqli_query($conn,$qry1);
                        if(!$result1)
                            {   
                            die("Sorry, Something went wrong. Please try again");
                            header("Location: index.php");
                            exit();
                            }
                        while ($row1 = mysqli_fetch_assoc($result1)) 
                            {   $name=$row1['sent_to'];
                                $time=$row1['time'];
                            if(($row1['payment']>10) && ($_GET['r']==$time) && ($_GET['l']==$name))
                                {
                                    echo $row1['entry']." ";
                                }
                            else
                                {   
                                    echo "error";
                                }
                            }
                         }
                  ?>

上面的代码打印结果以及错误消息，例如

entry1错误errorerrorerrorerrorerrorerror

请检查我在哪里做错了

Answer 1

感谢大家的关注。我只是限制了数据库的while循环结果，它正在工作。如果有更好的方法，您的摘要将受到欢迎。

这是已解决的代码供参考

 if(isset($_GET['l']))
                         {  $name=$_GET['l'];
                            $time=$_GET['r'];
                            $user=$_SESSION['username'];
                            $qry1="SELECT * from entry where username='$user' and time='$time' and sent_to='$name'";
                            $result1=mysqli_query($conn,$qry1);
                        if(!$result1)
                            {   
                            die("Sorry, Something went wrong. Please try again");
                            header("Location: index.php");
                            exit();
                            }
                        while ($row1 = mysqli_fetch_assoc($result1)) 
                            {   $name=$row1['sent_to'];
                                $time=$row1['time'];
                            if(($row1['payment']>10) && ($_GET['r']==$time) && ($_GET['l']==$name))
                                {
                                    echo $row1['entry'];
                                }
                            else
                                {   
                                    echo "error";
                                }
                            }
                         }
                  ?>