I am getting the above error when applying this statement using php:
$query = "insert into xxxsbr.bnk_tmp set Account = '".$wacct."',Date='".$msdate."',Reference ='".$msref."',Amount='".$msamt."',Category='".$mscat."'";
Which translates to this:
insert into xxxsbr.bnk_tmp set Account = 'HCJN',Date='2021-11-﻿15',Reference ='xxx-AUTHPBPYEFZEFT',Amount='-146.36',Category=''
and it fails in the php code with 'Incorrect Date Value' in the Date field.
It looks correct to me and if I cut and paste it into the MYSQL console, it works.
This should be simple and it escapes me.
Can someone please point me in the right direction?
This is under WAMPServer, Windows 10. PHP 7, MYSQL 5. All up to date.
There are 2 replies in this thread, which are not being displayed. Browsing this forum thread replies is available only to premium subscribers.
Go to the premium subscriptions page to learn how to become a premium subscriber and have full access to this forum.