number of bound variables does not match number of tokens..

Hi folks,
please help me to find this annoying bug.

    $query = $db->prepare("INSERT
                           INTO customers(name,city,address,phone,date)
                           VALUES(:name,:city,:address,:phone,date)");
 
    $query->execute(array(':name' => $name,
                          ':city' => $city,
                          ':address' => $address,
                          ':phone' => $phone,
                          ':date' => $date));
    $affected_rows = $query->rowCount();

PHP:

Table layout
customer_id[auto inc) - name - city - address - phone - date

 

You're missing a : in front of date in the values in the query