> That's it. There's nothing special to do.
Except if one insert fails and the others succeed, you run into a bit of
sync trouble. This is what transactions are for. You might want to consider
a BDB table type, which supports transactions, then you have the option to
rollback the other inserts if one of them fails.
Julian
on 4/18/01 6:33 PM, Steve Werby at [EMAIL PROTECTED] wrote:
>
> "Fates" <[EMAIL PROTECTED]> wrote:
>> 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);
>
> Add two more sets of statements like those you have for the first query.
> That's it. There's nothing special to do.
>
> --
> Steve Werby
> President, Befriend Internet Services LLC
> http://www.befriend.com/
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
