Jump to content

Archived

This topic is now archived and is closed to further replies.

drranch

mysql_insert_id() not returning inserted ID from auto increment column

Recommended Posts

mysql_insert_id() not returning inserted ID from auto increment column its returning 0.  The mysql_query is being added to my database and the auto increment is also being created, but the email I send to the customer is outputing the number 0 as the userid.

Here is my code…

$sql = mysql_query("INSERT INTO users (first_name, last_name, email_address, username, password,  signup_date)
VALUES('$first_name', '$last_name', '$email_address', '$username', '$password', now())", $database) or die (mysql_error());
if(!$sql){
$errors8="<font color=#FF0000><strong>There has been an error creating your account.&nbsp;<href=mailto:admin@test.com?=account_activation_failed>Please contact test’s customer service for further assistance.</font>";
} else {
$userid = mysql_insert_id();
if(isset($userid))
$success="<font color=white><strong>Your membership information has been mailed to your email address!_Please check it and follow the directions!</font>";
include "home.php";

Share this post


Link to post
Share on other sites
::) Ok fixed....

for some reason it wasn't looking at the last opened link identifier so I added the database to the mysql_insert_id() script

So now it looks like this and works!

$userid = mysql_insert_id($database);

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.