RE: [PHP-DB] Last Modified question..

You can use a TIMESTAMP field in the the record. When you INSERT a record, set the field to NULL; the time will automatically be entered. The same is true for files/records that are UPDATED. CREATE TABLE mytable ( first_name varchar(25) default "", last_name varchar(25) default "", bday date, timestamp timestamp ) $query = "INSERT INTO mytable VALUES ($first,$last,NULL)"; mysql_query($query); $query = "UPDATE mytable SET bday=$birthday WHERE last_name=$$last && first_name=$first"; mysql_query($query); rick -----Original Message----- From: Jay Paulson [mailto:jpaulson@lbjs.com] Sent: Tuesday, August 28, 2001 5:04 PM To: Justin Buist Cc: PHP DB list (E-mail) Subject: Re: [PHP-DB] Last Modified question.. A) It's a MySQL database that I'm using B) I'm using file_exsist() and to check the modified date I'm using filemtime() C) If I modify the permissions on the file wouldn't that possibly cause some security issues? Thanks, jay ----- Original Message ----- From: "Justin Buist" <jbuist@tridenttechnology.com> To: "Jay Paulson" <jpaulson@lbjs.com> Cc: "PHP DB list (E-mail)" <php-db@lists.php.net> Sent: Tuesday, August 28, 2001 4:44 PM Subject: Re: [PHP-DB] Last Modified question.. > a) What kind of database is this? > b) use fstat() to check the modification time on a specific file. > c) You will have to modify permissions so that the user your web server > runs as has 'read' permission on the file if you want to use fstat(). > > Justin Buist > Trident Technology, Inc. > 4700 60th St. SW, Suite 102 > Grand Rapids, MI 49512 > Ph. 616.554.2700 > Fx. 616.554.3331 > Mo. 616.291.2612 > > On Tue, 28 Aug 2001, Jay Paulson wrote: > > > I have a problem... I want to check the last modified time that a file was > > changed/updated. Actually, it's an employee database that I'm working on > > and I thought about just checking the last modified date on the file that > > the information was stored on. However, I get a permission denied error and > > I don't want to change the permissions of the file. Is there an easy way to > > check to see when the last time anyone logged in and updated their > > 'employee' information? > > > > Thanks, > > jay > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net