Hai, i want to design a database with fields name,currentdate and nextdate. This currendate and nextdate should be the actual date. It should be dyanmic also. I'm working in JSP and MySql. Is that possible to create such a database??? I don't want to store the dates into my table. I want the dates to be my fields in my table. Is that possible?? If anyone knows the answer, plz help me.....
I am a relative newbie for php/MySQL, and most of what I am doing is based on being self-taught using someone else's well-written code, and my own googling the answers to my questions.
I'm doing a php/MySQL page that reads data out of a MySQL database. Longer term, I'll do a data-entry screen allowing me to modify the database or add new records. For now, I'm just using phpmyadmin to data enter stuff.
Is there a way to set up a date field, Last_Update, that would automatically update to today's date any time a record was added or changed using phpmyadmin?
Not sure if I'm asking the question clearly. What I want would be that, let's say that I add a new record today, April 23. The Last_Update field for the record would automatically be April 23. If I go in and modify and part of that record on April 29, Last_Update automatically changes to April 29 for that record.