Re: insert syntax

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. . <phplists@woodenpickle.com> schrieb im Newsbeitrag news:20020410144238.61831.qmail@pb1.pair.com... > 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" <marc@chescolawyers.com> wrote in message > news:3CB44C6A.C325DCD5@chescolawyers.com... > > 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 > > marc@chescolawyers.com > > Bialecki & Bragg, PC > > p: 610-444-7508 > > f: 610-444-7548 > > > > http://www.chescolawyers.com/BB > > "Legal Directory, Services & Consumer Information for Chester County" > > > > > > > >