thanks for your reply. may pls. let me know the command for 1) MySQL options to log all operations to a file and date retreival 2) how can i find the command a user executed. with best wishes balwant -----Original Message----- From: Jason Wong [mailto:php-db@xxxxxxxxxxxx] Sent: Monday, September 27, 2004 2:46 PM To: php-db@xxxxxxxxxxxxx Subject: Re: User Activities On Monday 27 September 2004 16:43, balwantsingh wrote: > i am using PHP and MYSQL. > is there any command through which i can record which user modifiyed the > data through which command (insert / update / delete etc.) on which time > and date in a table in mysql. MySQL has options to log all operations to a file. If that is not sufficient for your needs then you'll have to write your own logging functions or structure all your tables and queries so that the logging info you require will be stored. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* Life is like a tin of sardines. We're, all of us, looking for the key. -- Beyond the Fringe */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php