inserting current date

Hello,

Given that the WebAssist MySQLi behaviours do not accept such generalized queries as:
"SELECT now();"
so I can gather than info and then insert current date and time into a database, then what is the recommended method for doing so?

My page contains a textarea message box in which people can make suggestions that are then (a) sent as an email, and (b) are inserted into a database.

I wish to display said messages on a dedicated page ordered by date stamp.

What is the simplest recommended WebAssist automated way to achieve this? Or should I continue as I am now, and insert my own code every time. I would of couse prefer something WebAssist devised, and so less prone to typos etc.!!!

Thanks.
KAB

You can just add a column to the database and set it to data type timestamp. Then set the default in the database to current_timestamp.

Then you don't have to account for it in the php code or insert at all. The database will insert the current timestamp automatically whenever a record is added.

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.