title: SQL SYNTAX ERROR PHP
body: <p>I am trying to echo how many minutes left from the specific date ( CURDATE() ).</p>
  
  <p>That's how i've done it:</p>
  
  <pre><code>public function getTimeLeft($ip)
  {
      $this-&gt;get = $this-&gt;pdo-&gt;prepare("SELECT DATE_FORMAT(TIMEDIFF(CURDATE(), 'nextVote')); FROM auths WHERE voter_ip = :ip");
      $this-&gt;get-&gt;execute(array(":ip" =&gt; $ip));
  }
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1582 Incorrect parameter count in the call to native function 'DATE_FORMAT'' in C:\xampp\htdocs\vote\includes\class\Vote.class.php:174 Stack trace: #0 C:\xampp\htdocs\vote\includes\class\Vote.class.php(174): PDOStatement-&gt;execute(Array) #1 C:\xampp\htdocs\vote\index.php(644): Vote-&gt;getTimeLeft('127.0.0.1') #2 {main} thrown in C:\xampp\htdocs\vote\includes\class\Vote.class.php on line 174
  </code></pre>
  
  <p>What is wrong with this syntax?</p>