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