
November 15th, 2003, 11:08 AM
|
|
|
|
Join Date: Apr 2007
Posts: 87
Time spent in forums: 9 m 44 sec
Reputation Power: 2
|
|
|
RE: createing new item
Hi,
It is relatively easy to insert a new record with PHP but I dont think you are asking this are you?
I think you are asking if a new record can AUTOMATICALLY be added when something happens to your `users` table.
What you could do with is a facility called triggers, and triggers arent yet written into MYSQL.
The manual states....
Quote: | Triggers are scheduled for implementation in MySQL version 5.1. A trigger is effectively a type of stored procedure, one that is invoked when a particular event occurs. For example, you could set up a stored procedure that is triggered each time a record is deleted from a transactional table and that stored procedure automatically deletes the corresponding customer from a customer table when all their transactions are deleted. |
Info taken from
http://www.mysql.com/doc/en/ANSI_diff_Triggers.html
IIHUWYSIHTH
If I Have Understood What You Said I Hope This Helps 
|