Hi,
Either I have misunderstood you; or my version of Navicat for MySQL does not have that feature. But anyways, inspired by what you said, I DO now have something, but I had to adjust the recordset within the PHP coding your MySQLi generated.
When I did what you said, I got two or thre 000000000 or whatever datestamps in the database. The only feature I could see was to adjust the datestamp on UPDATING a record, not on inserting it. And what I of course want is on inserting; not updating.
But inspired by what you said as well as something I read in a Google MySQLi query, I went back to play around with the recordset options.
The server behaviour was correctly picking up that the field was set to "timestamp".
I could then select the option that was set to "Date";
and then as the further option, within the MySQLi recordset, select the option "CurrentDate".
And as soon as I did that the "blank value" option changed to "Now", which is presumably immediately acfitvates the appropriate MySQAL function.
Whatever is going on, I now have the date being inserted into the database, and am a happy camper.
I shall go back and review a couple of other date thingies I have in some other files in which I had to jury-rig an option because I did not know this function was available in MySQLi ... ... ... but that can wait for another day.
Thank you very much.
