php - pg-admin "WHERE" 子句不能正常工作

Question

我想显示基于前一周的数据。我对 pg-admin 的查询是

"SELECT * FROM event  WHERE datetime BETWEEN NOW()-INTERVAL '6 DAYS' AND NOW()"

它在 pg-admin 编辑器中工作正常并向我显示正确的数据，但是当我将此查询实现到 php 代码时，它没有显示所需的结果。我的 php 代码是

$queryStr ="SELECT * FROM event  WHERE datetime BETWEEN NOW()-INTERVAL '6 DAYS' AND NOW()";
    $result = pg_query($conn,$queryStr);
    if (!$result) {
        echo "An error occurred in query.\n";
        exit;
    }
    $result = pg_fetch_assoc($result);      
    return $result; 

它只显示了一行任何解决方案？

标签： phppgadmin

Answer 1

使用类似下面的东西：

while ($row = pg_fetch_assoc($result)) 
{ 
echo $row['id']; 
echo $row['author']; 
echo $row['email']; 
}