[SOLVED] grabbing an auto increment number??

[aebstract]

Hello,

I am entering information in to a database. Everything enters 100% fine, the first column is an auto_increment id number. What I want to do is enter information in to another table, but I need to use that id number that is generated in one of the columns. (and it has to be pretty much instant with the first one, its for a register form) Is this possible? If so, how would I do it? Thanks!

[effigy]

mysql_insert_id.

[Orio]

mysql_insert_id()

 

Orio.

 

EDIT- I am getting slow...

[aebstract]

$result = mysql_query("INSERT INTO users (firstname,midname,lastname,email,password,date_signup,ip_signup,country,address1,address2,city,state,postal,telephone)".
"VALUES ('$firstname', '$midname', '$lastname', '$email', '$password', 'now()', '$ipsignup', '$country', '$address1', '$address2', '$city', '$state', '$postal', '$telephone')") or DIE(mysql_error());

$result2 = mysql_query("INSERT INTO map_users_roles (users_id,roles_id)".
"VALUES ('mysql_insert_id()', '3')") or DIE(mysql_error());

 

Okay, with that function in, it is placing '0' in the column. I also tryed mysql_insert_id(users_id) thinking that maybe I had to put the column name in place? What am I doing wrong here?

[Orio]

I think it's trying to place the string "mysql_insert_id()" into the int column so it enters 0. Try this:

 

$result2 = mysql_query("INSERT INTO map_users_roles (users_id,roles_id)".
"VALUES ('".mysql_insert_id()."', '3')") or DIE(mysql_error());

 

Orio.

[per1os]

It should just be mysql_insert_id($result); or just a blank modifier to get the last result's id.

 

 

[obsidian]

I think you may have the usage of the function backwards. Can you describe what you're trying to do? mysql_insert_id() returns the auto_incremented value of a newly inserted row, it doesn't tell you what the next ID is supposed to be:

<?php
$sql = mysql_query("INSERT INTO myTable (name) VALUES ('$val')");
$id = mysql_insert_id(); // returns the ID generated in the above query.
?>

[aebstract]

Thanks, both of you, for the information and all. I did what orio said with the ." ". and it helped, I wasn't even thinking about that.