Add data to three tables at once from one form

I know how to add data to one table but how do I add data to three tables from one form? I want to do this with just one form and on one web page so it doesn't post to another page. How do I set up the insert statement? $query = "INSERT INTO $table VALUES ('$menu_id', '$server', '$menunumber', '$menuname')"; $result = mysql_db_query($dbname, $query); <form enctype="multipart/form-data" method="post" action="<?php echo $PHP_SELF ?>"> Anyting special I have to do with the form submit? <INPUT type="submit" name="submenu" value="submenu"> <INPUT type=reset value="Reset">