PHP SQL More than one command…..Help

hi guys im making an alliance thing for my game and what it does is when a user creates an alliance i want to record the name of the alliance they typed in(goes into the ”alliance table” and then in ”name”) and the users id into the ”alliance_leader” in the alliance table. plus i want it so when this happens the alliances id is recorded on the users alliance id collum.

This is my database:

[QUOTE]

[B]The databases[/B]———–[B]The columns[/B]
Alliance – ————-ID, name, alliance_leader.

Users —————– ID, name, password, allianceid.

[/QUOTE]

ive done the recording of the name:

[code=php]$update = mysql_query(“Update alliance table set alliance_name = ‘$alliance_name’ where username = ‘$logged[username]'”)
or die(mysql_error());[/code]

can anyone help me to add to it, for it to record the alliance id and leader and the users alliance id.

if you know what im talking about please help:o

Also in #PHP _↴