mysql_insert_id() woes...should be very easy

[pufftissue]

Hi,

I basically can't seem to extract the auto_increment user_id field and use it in the next query. Would being on a mac have anything to do with this problem? I'm using MAMP with the standard settings. I hope it's not a configuration issue.

Why? I have tried to echo the value of user_id but nothing happens. No zero, no null, nothing.

However, the user_id is indeed being created; I just can't use it.

			$TableName = "roster";
			$SQLString = "INSERT INTO $TableName (first, last, email, password)
				VALUES ('$first', '$last', '$email', SHA('$password'))";
			$QueryResult = @mysqli_query($DBConnect, $SQLString) or  die ("<p>Error querying table:  $TableName </p>" . "<p>Error code " . mysqli_errno($DBConnect) 
											. ": " . mysqli_error($DBConnect) . "</p>");	
			$user_id = mysql_insert_id();  //this is the problemic area I believe
			echo "user id is: " . $user_id;  //nothing shows to the browser.

My table is set up correctly:
user_id is primary key, auto_increments
first
last
email
password

[NogDog]

You need to use [FONT="Courier New"]mysqli_insert_id()[/FONT]. 😉

[pufftissue]

Hi, unfortunately I did that and it doesn't work still.

I get an output: user id is:

in other words, it's blank.

However, if I query my table within mysql command line, it will have a user_id = 1, 2, 3, etc (i.e., it autoincrements correctly).

Obviously I want to take the user_id generated and work with it in another table.

Thanks!

Is there some type of setting that I need to enable or has there got to be a problem with my code?

[laserlight]

Did you use:

$user_id = mysqli_insert_id($DBConnect);

?

Also, have you considered using the object oriented version of MySQLi API?

[pufftissue]

THANK YOU SO MUCH, LaserWitch.

Long live Singapore :>