I've got a query that inserts data into a table.
"INSERT INTO `dbPosts` (`post`, `username_id`, `private`) VALUES ('$post', '$user', '1')";
When data is inserted it automatically creates an ID (incremented value) in the table row
I've got another query in the same php document that inserts data into another table:
"INSERT INTO `dbPrivate` (`username_id`) VALUES ('$user')";
How do I copy the ID which was automatically inserted in query1 into query2.