need help with inserting data in more than one table

[elements708]

Currently I have data being inserted into one table which is this

 

$sql = "INSERT INTO user (username, `password`, email, ip)

VALUES ('$username','$pass','$email','$ip')";

$result = mysql_query($sql, $connection) or die(mysql_error());

 

but I want to add another insert into which would be for another table called members how do i go about by doing that, thanks for your input everyone.

[Drezard]

Does it have the exact same column names?

 

Or else just write another question and execute it after this one?

 

Daniel

[elements708]

yes the column names are the same