Problem with mysql_insert_id()

[doubledee]

When I run this Prepared Statement...

// Build query.
$q2 = "INSERT INTO member(email, activation_code, salt, hash, first_name,
						username, register_ip, register_hostname, location, created_on)
			VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())";

// Prepare statement.
$stmt2 = mysqli_prepare($dbc, $q2);

// Bind variables to query.
mysqli_stmt_bind_param($stmt2, 'sssssssss', $email, $activationCode, $salt, $hash, $firstName,
					$username, $ip, $hostName, $location);

// Execute query.
mysqli_stmt_execute($stmt2);

// Capture New ID.
$_SESSION['memberID'] = mysql_insert_id();

 

 

I am getting this error...

Warning: mysql_insert_id() [function.mysql-insert-id]: A link to the server could not be established in /Users/user1/Documents/DEV/++htdocs/05_Debbie/members/create_account.php on line 269

 

What am I doing wrong?

 

 

Debbie

 

[scootstah]

You can't use the mysql extension in conjunction with the mysqli extension.

 

You need to do

mysqli_insert_id($dbc);

[doubledee]

You can't use the mysql extension in conjunction with the mysqli extension.

 

You need to do

mysqli_insert_id($dbc);

 

Why do you have $dbc in the parentheses?

 

 

Debbie

 

[scootstah]

Procedural style

mixed mysqli_insert_id ( mysqli $link )

 

Link

Procedural style only: A link identifier returned by mysqli_connect() or mysqli_init()

 

 

[doubledee]

Procedural style

mixed mysqli_insert_id ( mysqli $link )

 

Link

Procedural style only: A link identifier returned by mysqli_connect() or mysqli_init()

 

Okay, I missed that.

 

Thanks!

 

 

Debbie