3 messages in com.mysql.lists.mysqlInserting data to multiple table at once
FromSent OnAttachments
Fates18 Apr 2001 10:49 
Peter Skipworth18 Apr 2001 11:47 
Patrick Calkins18 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')";