Image

Imagejulisana wrote in Imagephp 🤔curious

Another quickie

Hello!

Just another quick question from me to you.

I simply need a little clarification on the mysql_insert_id() function that is available in PHP.

The definition on PHP.net reads: "Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query." Is this ID the number that is created in a column I defined (with Auto increment enabled) or is this something else entirely?

Say I have a table with two columns:
Column 1 = id_num (auto increment)
Column 2 = name

I want to insert a new name into the table and let the value for id_num generate automatically. Easy, right? Can I then call the mysql_insert_id() function and have it return the value in the first column that was created, or does it return a value that mysql uses but nobody else would need?