[macintosh]

I have a few tables where few users insert the data. For example:

User a inserts an entry in table 1.
User b inserts an entry in table 2.
User c inserts an entry in table 2.

Now I want to create a log file to display the above activities of all users. How I can do a simple log of this?
I just want to have a simple log file to display the above activities as:

User a inserted an entry in table 1.
...
..

Any ideas/especially a basic code example will be highly appreciated.

[Silvor]

PHP Code:

$LogFile = "filename_on_server.txt";
$fh = fopen($LogFile, 'w') or die("Can't Open File");
$stringData = "User a inserted an entry into table 1\n";
fwrite($fh, $stringData);
fclose($fh); 

[macintosh]

Sorry if my question was not clear, I meant to ask if a user inserts some data in mysql database, then i want to log that action)

For example, User A inserts data

mysql_query("INSERT INTO User (FirstName, LastName)
VALUES ('Peter', 'Griffin')");

Another user inserts some data in other table.

mysql_query("INSERT INTO Phone(Name)
VALUES ('123')");

After the user has inserted the data successfully; I want to log the above activity, such as
A User inserted his Name.
A user inserted his phone number.

I'd appriciate any help.