Insert into more than one table

[tryin_to_learn]

What's the best way to write a SQL statement so it will insert data from a form into more than one table? For example, I'd like to be able to do something like:

$sql = "INSERT INTO attendees SET firstName='$firstName', lastName='$lastName', typeOfAttendeeID='1', conventionID='1'";

and simultaneously do this:

"INSERT INTO relationships SET role='father', typeOfAttendeeID='1', conventionID='1'";

[Roger_Ramjet]

Not possible.

[pyro3k]

you can do the following

$sql = "INSERT INTO attendees SET firstName='$firstName', lastName='$lastName', typeOfAttendeeID='1', conventionID='1';
INSERT INTO relationships SET role='father', typeOfAttendeeID='1', conventionID='1'";

and then use mysqli_multi_query( $sql ) (only avaliable in php5)