drranch Posted August 14, 2006 Share Posted August 14, 2006 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. <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"; Quote Link to comment Share on other sites More sharing options...
drranch Posted August 14, 2006 Author Share Posted August 14, 2006 ::) 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() scriptSo now it looks like this and works!$userid = mysql_insert_id($database); Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.