[SOLVED] Inserting data into two databases at the sam time

[B34ST]

I have a script in which i need to insert some data into 2 databases at the same time but i need to insert it into the first db then get the id(auto increment) which would be created and some other data into the 2nd database using the id from the first db

 

I have tried the following which inserts the data into the first db but then cand find the id afterwards and cant contiue:

        $sql = "INSERT into team_names (name)
	VALUES ('$team_name')";
$result = mysql_query($sql) or die("Could not query: " . mysql_error());

if ($result)
{
	$sql = "SELECT id from team_names WHERE name=$team_name";
	$result = mysql_query($sql) or die("Could not query: " . mysql_error());
	$row = mysql_fetch_array($result);
	$team_id = $row['id'];

	$sql = "INSERT into team_members (user_id, team_id, captain)
		VALUES ('$user_id', '$team_id', '1')";
	$result = mysql_query($sql) or die("Could not query: " . mysql_error());
}

 

anybody know how this can be done?

[Trium918]

<?php
$sql = "INSERT into team_names (name)
	VALUES ('$team_name')";
$result = mysql_query($sql) or die("Could not query: " . mysql_error());

if ($result)
{
    //try adding this
      $user_id = mysql_insert_id();

      $sql = "SELECT id from team_names WHERE name=$team_name";
     $result = mysql_query($sql) or die("Could not query: " . mysql_error());
	$row = mysql_fetch_array($result);
	$team_id = $row['id'];

	$sql = "INSERT into team_members (user_id, team_id, captain)
		VALUES ('$user_id', '$team_id', '1')";
	$result = mysql_query($sql) or die("Could not query: " . mysql_error());
}
?>

 

 

 

[B34ST]

that wokrs great thank you very much