Update mysql date field php

Asked 11 years, 2 months ago. Active 7 years, 5 months ago. Viewed 6k times. How doesn't this work? Please help!!! Improve this question. Ricardo Ricardo 1 1 gold badge 10 10 silver badges 16 16 bronze badges. Please read up on SQL injection and how to prevent it. Your query is vulnerable! Add a comment. Active Oldest Votes. Improve this answer.

Justin Ethier Justin Ethier k 49 49 gold badges silver badges bronze badges. I don't get any error message. It simply doesn't update. The PHP doesn't seems to work Here before updating the current login info you have to collect the previous record and display.

Altering table structure to add date time with record insert We can change the structure of the table and add one new field to store date and time automatically at the time of record insert. If our table is already having data then we have to set this new field as NULL as already existing records won't have data for this new field.

First Name. Last Name. Subscribe to plus2net. Be the first to post comment:. However, it can be used with any time format functions to change it and display it. So use default date and time format as provided by MySQL i. Use the following query to display result. So it will display error message. Skip to content. Change Language. Related Articles. Table of Contents. Improve Article. Save Article.