I've looked through the various answers and none of them seem to be helping. I have a simple Insert Query that is working as expected. Nothing special
$user_account_query = mysqli_query($dbc,"
INSERT INTO ACCOUNT (EMAIL, IS_OPEN)
VALUES ('$email', 1)")
or die ('Could not add user: '. mysql_error());
It is successfully inserting the record into my db
I also have an auto-incrementing column in the table being called
However, when I call
$message = mysql_insert_id();
I get 0. Does anyone have any advice on how to get the correct ID?