mysql - Show sql records where date is in the future php

209

I am trying to create an SQL query that will show up coming coach trips on a web page. I would like the page to drop any trips that have already happened. here is my code so far. but I am getting this error when I try it, The error message:

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given 
in /homepages/3/d383808630/htdocs/php/checker/show.php on line 67

Here is the code, Please help!

$result = mysqli_query($con,"SELECT * FROM checker WHERE date  > GETDATE()");

while($row = mysqli_fetch_assoc($result))
  {
  echo 
  "<div class='destpic'>" . $row['id'] ."</div>" . 
 "<div class='topinfo'><p class='topinfo'><span class='topinfo'>" .
  $row['date'] . "</span><br /><span class='topinfo'>" . 
  $row['displayer'] . "</span><br /><span class='topinfo'> " . 
  $row['forum'] . "</span><br /><span class='topinfo'> ";
  }
mysqli_close($con);
?> 

People are also looking for solutions to the problem: javascript - Submit button not working in Bootstrap form

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.