How do I automatically do an SQL insert when creating a new node? When creating a new node of a certain type, I want an SQL insert to be made at the same time.
The insert operation needs to use the node ID from the node just created, such as INSERT INTO my_own_db (nid) VALUES ('last inserted node id').
You've to create your own module and after use a hook_node_insert you'll receive a $node object with all informations you need.