Jump to content


Photo

mysql_insert_id() not returning inserted ID from auto increment column


  • Please log in to reply
1 reply to this topic

#1 drranch

drranch
  • Members
  • PipPipPip
  • Advanced Member
  • 78 posts

Posted 14 August 2006 - 04:18 AM

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";


#2 drranch

drranch
  • Members
  • PipPipPip
  • Advanced Member
  • 78 posts

Posted 14 August 2006 - 04:45 AM

::) 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);




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users