you can only insert into one table at a time. if these statements depend on another and your db is able to generate transactions, then you can insert into your tables one by one and then commit the transaction on success or rollback it in the end, if a insert fails. if you're db isn't able to generate transactions, you have to work around this within you application.
Advertising
. <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > These guys probably have one for you.. "If you give a man a fish..." (as was > stated earlier in the week) > > http://www.mysql.com/doc/I/N/INSERT.html > > Later, > > Bob Weaver > > "Marc S. Bragg" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hi there: > > > > Can canyone give me a basic insert statement to insert into two or more > > tables, variables and data from one form; i.e., insert the input into > > two or more tables at the "same" time? > > > > thanx > > > > -- > > Marc S. Bragg > > [EMAIL PROTECTED] > > Bialecki & Bragg, PC > > p: 610-444-7508 > > f: 610-444-7548 > > > > http://www.chescolawyers.com/BB > > "Legal Directory, Services & Consumer Information for Chester County" > > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
