you can do it by [multiple statement details][1]
like this:
$sql = "INSERT INTO TABLE1(field1, field2, field3) VALUES('value1',value2,value3); INSERT INTO STOCK(field) VALUES ('value1');";
multi_query($conn,$sql);
you need to use mysqli_* for this. I assume $conn is your mysqli connection
[1]: http://php.net/manual/en/mysqli.quickstart.multiple-statement.php
you can do it by
[multiple statement details][1]
like this:
$sql = "INSERT INTO TABLE1(field1, field2, field3) VALUES('value1',value2,value3); INSERT INTO STOCK(field) VALUES ('value1');";
multi_query($conn,$sql);
[1]:http://www.php.net/manual/en/mysqli.quickstart.multiple-statement.php
you need to use `mysqli_*` for this. I assume `$conn` is your `mysqli` connection