Inserting into two tables at same time

[salimalisalim]

Hi,

I have a form, while submitting this i need to store the values into two different tables in a database,Some values will store in a table and others will store in a another table. How can i write it's query ?

For Example,

$sql="INSERT INTO table1 (field1, field2, field3,field4)
VALUES
('$_POST[column1]','$_POST[column2]','$_POST[column3]','$_POST[column4]')";


$sql2="INSERT INTO table2 (field5, field6, field7,field8)
VALUES
('$_POST[column5]','$_POST[column6]','$_POST[column7]','$_POST[column8]')";



For me like this, Only one $sql values are only inserting, $sql2 values are not inserting.


Thanks in Advance

[.josh]

Post the code that actually executes it. Multiple queries in a single request may or may not be possible, depending on what code you're using.