Quick mySQL question.

[Anon]

Okay, here it is:

I have two identical tables. I want some form submission info to be inserted into both tables but I want to do it with only one query. Sooooo. . .would something like this work?

$check = mysql_query("INSERT into $table1, $table2
set sender = '$name',
host = '$host", $dblink);

or does it need to be:

$check = mysql_query("INSERT into $table1 AND $table2
set sender = '$name',
host = '$host", $dblink);

or am I completely wrong on both?

Thanks in advance!

[Anon]

I think this is impossible and you would need to run two queries

[Anon]

I believe you may use store-precedure in mySQL to process two Insert SQL. And, you can call this procedure anytime to insert into two tables. Well, I have no experience in store-precedure but I hope this may help you.