Multiple updation of tables?

Well, yes this is certainly possible. It's a bit difficult to help without knowing the specifics, have you read the MySQL documentation on stored procedures?

Talking abstractly, you'll need a procedure that receives the id as a parameter, then updates both tables. Sounds pretty straight-forward. Another way to do it is using a trigger, that updates the second table whenever the first is written to.

Again, let us know some details of what you're trying to do and where you're getting stuck and we'll try to help.