ayuda con insertar modificado por y fecha
por favor necesito que me ayuden con algo sencillo para el que sabe pero complicado para los que no sabemos y la verdad hasta ahora estoy empezando con esto de mysql.
Estoy haciendole a un cliente una base de datos sencilla , la cual ya la tengo asi:
Tengo 1 tabla que se llama formulario con los siguientes campos:
proceso
empresa
vehiculo_placa
fecha_siniestro
propietario
conductor
fiscalia
juzgado
aseguradora
actuaciones
Ya funciona perfecto tengo 3 tipos de usuarios con su respectivo login y password.
1 como superadminsitrador que puede ver,editar y borrar registros , 2 como administradores que pueden ver y editar solamente y 5 como usuarios que solo pueden ver los registros.
El superadminstrador osea el cliente quiere que al entrar a ver lo que se a actualizado en la base de datos le diga quien modifico o agregó algun campo y en que fecha lo hizo.
He intentado lo siguiente sin ningun resultado:
INSERT TO formulario (actuaciones) VALUES (NOW())
lo del ususario ni lo he intentado.
Para crear las paginas de consulta de todos los usuarios utilizo PHP Generator fot MYSQL.
Utilizo MySQL version 4.1.22-standard
Gracias de Antemano por la respuesta
Saludos
JUAN POLANCO
---------
"EL QUE NO SABE ES COMO EL QUE NO VE"
Subject
Views
Written By
Posted
54838
July 11, 2006 07:51AM
8920
July 21, 2006 09:35AM
7115
July 24, 2006 08:37AM
4209
February 25, 2010 05:22PM
6112
May 17, 2010 02:44AM
3505
August 30, 2010 08:14AM
3514
September 15, 2010 04:21PM
3891
November 09, 2010 06:58AM
6087
June 07, 2010 03:05PM
4313
August 31, 2011 05:59AM
6599
July 28, 2006 08:22AM
5779
March 15, 2008 10:59AM
5279
March 17, 2008 04:10AM
14613
April 22, 2008 01:27PM
8752
June 16, 2008 04:40PM
6638
July 28, 2006 05:43PM
7839
August 30, 2006 09:33AM
6121
July 09, 2007 10:47AM
5278
May 23, 2008 12:34AM
8842
May 17, 2008 07:03AM
6938
May 22, 2008 12:07PM
5786
July 25, 2008 12:46PM
8809
November 14, 2007 03:15AM
8816
November 14, 2007 12:26PM
6279
January 10, 2008 10:39AM
5709
March 04, 2008 11:50AM
7522
June 03, 2008 10:58AM
7185
January 17, 2009 09:27PM
5485
January 18, 2009 07:33AM
5563
January 21, 2009 07:53PM
6201
January 24, 2009 09:09PM
5272
January 22, 2009 12:12AM
5356
January 23, 2009 04:52PM
3673
March 18, 2010 07:16PM
6663
January 21, 2008 02:07PM
5803
January 21, 2008 04:04PM
9436
January 22, 2008 10:56AM
6645
January 22, 2008 02:47PM
6112
February 09, 2008 05:56AM
8078
June 13, 2011 08:59AM
ayuda con insertar modificado por y fecha
7941
February 09, 2008 05:58AM
6336
February 11, 2008 05:28PM
5528
May 11, 2008 12:31PM
12124
February 12, 2008 06:04PM
7899
March 11, 2008 05:17AM
4636
April 10, 2010 06:07PM
8914
August 25, 2008 07:22PM
9210
March 23, 2008 09:27AM
5691
April 19, 2008 05:08PM
5248
May 11, 2008 12:28PM
7876
March 28, 2008 10:20AM
6847
June 05, 2008 08:21AM
5179
May 20, 2009 06:30PM
5596
April 04, 2008 08:20AM
7903
April 18, 2008 12:52PM
5130
May 20, 2009 06:27PM
5977
April 29, 2008 04:17AM
8303
May 12, 2009 02:56PM
5863
May 13, 2009 01:26AM
5748
April 30, 2008 02:21PM
5472
June 05, 2008 08:02AM
7563
May 02, 2008 01:15PM
5554
May 08, 2008 08:13PM
5489
May 05, 2008 06:25AM
5800
May 08, 2008 09:05AM
7071
May 08, 2008 03:17PM
7976
June 04, 2008 01:47PM
7036
May 19, 2008 03:50AM
5133
May 29, 2008 04:34AM
5242
May 29, 2008 05:54AM
5484
June 02, 2008 11:47AM
12091
June 04, 2008 02:01PM
5373
June 05, 2008 06:07AM
6361
June 05, 2008 07:46AM
6816
June 09, 2008 02:31AM
4929
June 09, 2008 09:53AM
5273
June 11, 2008 10:47AM
5950
June 16, 2008 06:28AM
5399
June 24, 2008 08:32PM
4433
March 26, 2009 11:07AM
4691
March 26, 2009 12:15PM
7971
September 03, 2008 04:34PM
10047
September 05, 2008 04:09AM
5609
December 14, 2008 11:49AM
7981
May 19, 2009 08:31AM
5206
May 19, 2009 08:43AM
5590
August 30, 2009 09:27PM
6093
May 26, 2009 05:30PM
4521
June 12, 2009 04:14PM
4396
July 29, 2009 08:59AM
4378
August 02, 2009 09:19PM
5118
August 02, 2009 03:18PM
4807
August 28, 2009 06:55PM
8094
August 31, 2009 03:02PM
5470
September 07, 2009 03:51AM
4021
February 24, 2010 03:37PM
5166
September 14, 2009 01:54PM
5254
September 24, 2009 09:43PM
4293
September 25, 2009 09:30AM
4651
October 07, 2009 01:51AM
6300
November 05, 2009 05:09PM
4636
November 25, 2009 06:51AM
7203
November 26, 2009 07:27AM
3719
November 26, 2009 04:13AM
4844
December 08, 2009 03:56PM
4158
December 28, 2009 10:31PM
4778
February 02, 2010 09:55AM
5199
February 11, 2010 12:06AM
11410
February 12, 2010 08:35AM
7456
February 12, 2010 09:20AM
4574
March 01, 2010 03:08PM
3864
March 03, 2010 08:23AM
5902
March 05, 2010 07:57AM
3406
March 06, 2010 04:37PM
4920
March 08, 2010 03:35PM
14086
March 29, 2010 10:12AM
4053
April 10, 2010 05:46PM
5367
April 13, 2010 03:43PM
3649
August 08, 2010 03:15PM
3461
August 08, 2010 03:54PM
2460
September 15, 2010 10:06AM
14123
September 18, 2010 10:24AM
3872
October 11, 2010 06:20PM
2729
October 10, 2010 10:05AM
2421
November 13, 2010 05:53AM
2749
October 18, 2010 04:05PM
2548
October 18, 2010 07:19PM
2253
October 18, 2010 07:34PM
2964
October 19, 2010 02:52PM
2925
October 25, 2010 09:30AM
2423
October 25, 2010 11:16AM
2236
January 14, 2011 05:37AM
2545
January 20, 2011 03:13PM
2625
January 23, 2011 09:41AM
3911
February 14, 2011 09:18AM
3474
January 31, 2011 04:19PM
3376
February 02, 2011 11:41AM
5199
March 03, 2011 02:57PM
2236
March 17, 2011 01:35PM
2728
July 30, 2011 10:51PM
1819
August 15, 2011 03:50PM
2877
September 20, 2011 10:54AM
1700
September 20, 2011 01:53PM
1740
October 14, 2011 08:21AM