[RESOLVED] Getting the auto_increment from 1 table to a different table

[mccloud]

okay let me explain this one and let me try to eplain this to where u guys understand me this time so please let me try okay when doing <?php {
$POST = valid_post($POST);

	$query2 = "INSERT into `divisions_team_list` (division, division_approved, tag, title,  location, location2, leader, manager, scheduler, irc_network, irc_channel, post, password) values(\"".$_GET['d']."\", \"1\", \"".$_POST["tag"]."\", \"".$_POST["title"]."\", \"".$_POST["location"]."\", \"".$_POST["location2"]."\", \"".$_SESSION["xpl_gfx_suserid"]."\", \"".$_POST["manager"]."\", \"".$_POST["scheduler"]."\", \"".$_POST["irc_network"]."\", \"".$_POST["irc_channel"]."\", \"".$_POST["post"]."\", \"".md5("!".md5("*".$_POST["password"]."*")."!")."\")";
	$result2 = mysql_query($query2);
	$query3 = "INSERT into `divisions_team_members` (division, teamid, playerid, GUID) values(\"".$_GET['d']."\", \"6\", \"".$_SESSION["xpl_gfx_suserid"]."\", \"".$_POST["GUID"]."\")";
	$result3 = mysql_query($query3);
 	print '<div id="news">'; ?>

the \"6\", from $query3 amd that post is the teamid i need the 6 to get the auto_increment from divisions_team_list into the teamid in table divisions_team_members how do i do that so when they register the team it will auto add them to it?

[mccloud]

 else
	{
	 	$_POST = valid_post($_POST);

	$query2 = "INSERT into `divisions_team_list` (division, division_approved, tag, title,  location, location2, leader, manager, scheduler, irc_network, irc_channel, post, password) values(\"".$_GET['d']."\", \"1\", \"".$_POST["tag"]."\", \"".$_POST["title"]."\", \"".$_POST["location"]."\", \"".$_POST["location2"]."\", \"".$_SESSION["xpl_gfx_suserid"]."\", \"".$_POST["manager"]."\", \"".$_POST["scheduler"]."\", \"".$_POST["irc_network"]."\", \"".$_POST["irc_channel"]."\", \"".$_POST["post"]."\", \"".md5("!".md5("*".$_POST["password"]."*")."!")."\")";
	$result2 = mysql_query($query2);
	$query3 = 'SELECT *FROM `divisions_team_list` ORDER BY `id` DeSC LIMIT 1';
	$result3 = mysql_query($query3) or die(mysql_error());
	$query4 = "INSERT into `divisions_team_members` (division, teamid, playerid, GUID) values(\"".$_GET['d']."\", \"".$query3["id"]."\", \"".$_SESSION["xpl_gfx_suserid"]."\", \"".$_POST["GUID"]."\")";
	$result4 = mysql_query($query4);
 	print '<div id="news">';
[\php]
When it does that it will put a S for the team_id but i need it to get the team thats just been register and the ID for that team to go into the team_id part of that instead of the S

[NogDog]

First: please learn to use the

 tag[/url] around your code samples so that we can read them.

Anyway, I think what you're looking for is the [man]mysql_insert_id[/man]() function.

[mccloud]

NogDog wrote:

First: please learn to use the

 tag[/url] around your code samples so that we can read them.

Anyway, I think what you're looking for is the [man]mysql_insert_id[/man]() function.[/QUOTE]
Example of the mysql_insert_id() function. please

[HalfaBee]

www.php.net/mysql_insert_id

[mccloud]

HalfaBee wrote:

www.php.net/mysql_insert_id

Don't Understand and yea i need the new id from the team list not the members part so help me plz

[Weedpacket]

mccloud wrote:

Don't Understand and yea i need the new id from the team list not the members part so help me plz

If this illustrates your skill at English then I'm not surprised. I've got better things to do than try to decrypt your writing.

But what you're wanting to do is:

1. insert into the team list

2. Use mysql_insert_id to get the id of the record you just inserted

3. Insert into the member list, including the id you retrieved in the previous step

[HalfaBee]

$query3 = 'SELECT *FROM `divisions_team_list` ORDER BY `id` DeSC LIMIT 1';
$result3 = mysql_query($query3) or die(mysql_error());
$r = mysql_fetch_assoc( $result3 );
$lastID = $r['id'];

[bradgrafelman]

Note that using [man]mysql_insert_id/man would be far more efficient that running another query (by the way - that's a very unoptimized query; you should hopefully NEVER use 'SELECT *'...).

[HalfaBee]

heh, I didn't read the code that closely 🙁

$result2 = mysql_query($query2);
$id = mysql_insert_id();