Reply To: Database Error (front.php) [Column count doesn't match value count at row 1]

$wpdb->query( $wpdb->prepare(“INSERT INTO “.$wpdb->prefix .”reservations(name, email, arrival, departure, room, number, childs, country, custom, customp, reservated, user )
VALUES (%s, %s, %s, %s, %d, %d, %d, %s, %s, %s, NOW(), %d )”, $val_name, $val_email, $val_fromdate_sql, $val_todate_sql, $val_room, $val_persons, $val_childs, $val_country, $val_custom, $val_customp, 0 ) );