Last Modifed Code Help

chugger93

I bought this script that allows for keeping logins/passwords stored for viewing on the web. Its for work.
http://www.esoftpro.com/demo/opm/index.php

However, I want to modify the script a little bit. I want in the footer to be able to say "Last Updated On (date)" So my boss knows when the last time I added/changed an entry.

I know theres a filemtime function you can use, but thats only for files itself. I want to show the modified data on the database entry that I make or edit.

Any ideas on how to do this? Or can give me the code? I can provide code/files

AstroTeg

This is a database entry you want to show the time of an insert or update? If so, check out the timestamp functionality in the database you are using. From the sounds of it, it'll do everything you need with just the simple addition of a field.

chugger93

Right, I want to be able to show the last modified data when I insert of update a record. Then output it to the script footer part.

Here is the contents of my SQL that I imported.

I could use some help with inserting this new field, and writing the syntax to show the modifed data code. Thanks!

CREATE TABLE cat (
cid int(10) NOT NULL auto_increment,
ctitle varchar(255) NOT NULL default '',
cicon varchar(255) NOT NULL default '',
PRIMARY KEY (cid)
) TYPE=MyISAM AUTO_INCREMENT=10 ;

INSERT INTO cat VALUES (6, 'Communications', '');
INSERT INTO cat VALUES (4, 'Academic', '12');
INSERT INTO cat VALUES (8, 'Software Keys', '');
INSERT INTO cat VALUES (9, 'To-do List', '');

CREATE TABLE entry (
eid int(10) unsigned zerofill NOT NULL auto_increment,
etitle varchar(255) NOT NULL default '',
elogin varchar(255) NOT NULL default '',
epw varchar(255) NOT NULL default '',
ecdate varchar(255) NOT NULL default '',
eicon int(4) NOT NULL default '0',
eurl varchar(255) NOT NULL default '',
enote text NOT NULL,
cid int(10) NOT NULL default '0',
PRIMARY KEY (eid)
) TYPE=MyISAM AUTO_INCREMENT=29 ;

INSERT INTO entry VALUES (0000000026, 'WebHostingTalk.com', 'abcdef', '123456', '1096762353', 32, 'http://www.webhostingtalk.com', '', 7);
INSERT INTO entry VALUES (0000000023, 'Textpad 4.7.3', 'abcdef', '123456', '1096762267', 13, 'http://www.textpad.com', '', 8);

CREATE TABLE pref (
type varchar(20) NOT NULL default '0',
value varchar(10) NOT NULL default '0',
format varchar(10) NOT NULL default ''
) TYPE=MyISAM;

INSERT INTO pref VALUES ('mask_pw', '0', 'yn');
INSERT INTO pref VALUES ('button_url', '1', 'yn');
INSERT INTO pref VALUES ('button_copy', '1', 'yn');
INSERT INTO pref VALUES ('button_genpw', '1', 'yn');

AstroTeg

Originally posted by chugger93

I could use some help with inserting this new field, and writing the syntax to show the modifed data code. Thanks!

Sorry, I'm taking this as "please write the code for me because I don't know how." If you were paying my bill rate, then I'd be more than happy to modify your code for you.

In the meantime, check out the MySQL web site. There's a search box in the top right. Put in "timestamp." You'll see some search results. Go for the one that says "Overview of Date and Time Types." It will describe how timestamp works. If you go back to the results, you'll find some examples of how to work with the timestamp field.

If you have a more specific question, please ask!