I need a syntax

[Trium918]

What would be the syntax for inserting data into

two different database tables?

 

Maybe something like this

<? $result = mysql_query("insert into members_info,members_address values"); ?>

[Trium918]

Somebody knows something!!!

[clown[NOR]]

maybe something like this?

 

INSERT INTO table1,table2 ('field1', 'field2', 'field3') VALUES ('value1', 'value2', 'value3')

[bubblegum.anarchy]

I am not sure inserting into more than one table at a time with the one query is possible..

 

EDIT just use two queries... how else are you going to link the members_address without an auto increment id of the members_info?

[Ekate]

as I correctly understood you need to insert data in two tables or not insert nothing.

Probably in this case you can use transaction.

the sequence is following:

• begin transaction tr_name
  
• insert into table1...
  
• insert into table2...
  
• commit transaction tr_name
  

 

you should check the syntax of transactions in MySQL

 

 

[fenway]

You can't insert into more than one table at a time.