[Resolved] Two insert queries, one having to know the auto increment of the other

[Tad]

I'm not even sure if this is possible, but I have two insert queries:

			$q="INSERT into ibf_character_registry (charID,date,pending,username,userID) 
			VALUES ('',now(),'$pending','$username','$userID')";
			$result= mysql_query($q, $connection) or die ("Could not execute query : $q." . mysql_error());

		$q="INSERT into ibf_character_trades (tradeID,charID,tradelistID,rankID) 
		VALUES ('','$charID','$trade1','$rank1'),('','$charID','$trade2','$rank2')";
		$result= mysql_query($q, $connection) or die ("Could not execute query : $q." . mysql_error());

The problem is though is that the second one won't work because it has to rely on the auto increment of charID. So I was wondering if it is possible to get the current charID, or somehow make it so the second query can actually read the previous query's charID. If that makes any sense at all. :/

Edit: Wait, I got it. ^;

[czambran]

Just in case other people are having the same problem. After you do the first insert(the one with the autonumber) you can use the command mysql_insert_id to retrieve the number generated by the autonumber field and use that for the second query.