mysql_insert_id() returns 0

by

According to the manual mysql_insert_id returns:

The ID generated for an AUTO_INCREMENT column by the previous query on
success, 0 if the previous query does not generate an AUTO_INCREMENT
value, or FALSE if no MySQL connection was established.

Since it does not give you false and not the correct number it indicates that the queried table didn’t generate an auto-increment value.

There are two possibilities I can think of:

  1. Your table doesn’t have an auto_increment field
  2. Since you doesn’t provide the link to the mysql_insert_id() but using a link with mysql_query() it might not be the correct table that’s queried when retrieving the last inserted id.

Solution:

  1. Make sure it has an auto_increment field
  2. Provide the link aswell: $waarde = mysql_insert_id($this->db);

More Related Contents:

  1. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  2. Search engine PHP return error [closed]
  3. How to include a PHP variable inside a MySQL statement
  4. How do you connect to multiple MySQL databases on a single webpage?
  5. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  6. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  7. How can I write SQL for a table that shares the same name as a protected keyword in MySql? [duplicate]
  8. MySQLi count(*) always returns 1
  9. Using Mysqli bind_param with date and time columns?
  10. Formulas to Calculate Geo Proximity
  11. How do I insert multiple checkbox values into a table?
  12. Get all child, grandchild etc nodes under parent using php with mysql query results
  13. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  14. Laravel Migration table already exists, but I want to add new not the older
  15. Saving images in database mysql
  16. I cannot use mysql_* functions after upgrading PHP
  17. Using utf8mb4 with php and mysql
  18. how do I get month from date in mysql
  19. mysql_connect VS mysql_pconnect [closed]
  20. How do I save PHP session data to a database instead of in the file system?
  21. Strange problem with the length of the field gotten from database [duplicate]
  22. Difference between mysql_fetch_array and mysql_fetch_row?
  23. MySQL, how to insert null dates
  24. Can I detect and handle MySQL Warnings with PHP?
  25. Escaping SQL queries in Codeigniter
  26. mysql_fetch_array skipping first row
  27. 500 Internal Server Error?
  28. How to write a stored procedure in phpMyAdmin?
  29. Aggregated query without GROUP BY
  30. mysql count into PHP variable

Leave a Comment