<div>
ys...it is possible for inserting into 2 tables with one tables...<br />

</div>


ys...it is possible for inserting into 2 tables with one tables...


<div>
yes, you can - there is no way to insert into 2 tables with one SQL.<br />
<br />
TIP: if you insert 2 records into the same table you can use<br />
<br />
insert into TABLE (field1,field2) values (val1_1,val_2),(val2_1,val<wbr />2_2)
</div>


yes, you can - there is no way to insert into 2 tables with one SQL.

TIP: if you insert 2 records into the same table you can use

insert into TABLE (field1,field2) values (val1_1,val_2),(val2_1,val2_2)

<div>
So it is legal to make to insertions in one right after the other like my example?
</div>


So it is legal to make to insertions in one right after the other like my example?

<div>
So it is legal to make two insertions, one right after the other like my example?
</div>


So it is legal to make two insertions, one right after the other like my example?

<div>
<div class="content wysiwyg-content">
Can you do something like this:<br />
<br />
$result = mysql_query($sql,$connecti<wbr />on) or die(&quot;Couldn't execute insert.&quot;);<br />
&nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
$result2 = mysql_query($sql2,$connect<wbr />ion) or die(&quot;Couldn't execute 2nd insert.&quot;);<br />
<br />
<br />
If not is it possible to insert into 2 different tables in one statement?
</div>
</div>


Can you do something like this:

$result = mysql_query($sql,$connection) or die("Couldn't execute insert.");
     
          
$result2 = mysql_query($sql2,$connection) or die("Couldn't execute 2nd insert.");


If not is it possible to insert into 2 different tables in one statement?

IS a Double insert illegal?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.