Inserting data to multiple table at once - Fates - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlInserting data to multiple table at once

From	Sent On	Attachments
Fates	18 Apr 2001 10:49
Peter Skipworth	18 Apr 2001 11:47
Patrick Calkins	18 Apr 2001 12:50

Subject:	Inserting data to multiple table at once
From:	Fates (fate...@home.com)
Date:	04/18/2001 10:49:28 AM
List:	com.mysql.lists.mysql

How do I insert data into multiple tables without having to use multiple

insert statements? Can I just do Insert into table1 (data) table2 (data) table3 (data) or do I have to use seperate INSERT statements for each table? I would like to add all at once from web page form

$query = "INSERT INTO $table VALUES ('$menu_id', '$server', '$menunumber', '$menuname')";