How to get autoinc field value after sql INSERT?

[bulrush]

- I am inserting a new record into a table called "parts". The key field is "partid", which is autoincremented.

- After I do the insert, how do I get the value for partid for the new record? I cannot select the record because there are no unique combinations of fields to select on.

 

Here is my code to insert the new record into table "parts".

            //Insert new part.
            $query="INSERT INTO parts (modelnum, prodcat, ".
            "prodname, prodsubname, createuser, createdate) " .
            "VALUES ( ".
            "'".$modelvar."', " .
            "'".$prodcatvar."', ".
            "'".$prodnamevar."', ".
            "'".$prodsubnamevar."', ".
            "'".$_SESSION['username']."', ".
            "NOW() ".
            ");";
            $result=mysqli_query($dbc,$query);
            if (!$result)
                {
                $msg=mysql_error().'<br/>Could not run SELECT. '; //There was an error.
                crError($_SERVER['PHP_SELF'].' line '.__LINE__,$msg,true);
                }
            else {
                $s='Inserted new product cat='.$prodcatvar.', model='.$modelvar;
                crInfomsg($s);
                }
            }
    

 

Thank you.

 

[Alex]

mysql_insert_id

[radar]

$id = mysql_insert_id(); but alex beat me to it

[bulrush]

So that returns the key field value of the previous INSERT statement in SQL? The autoinc field is the only key field.

 

 

[radar]

yes, if your current id is 725 and you run an insert, that id owuld be 726 mysql_insert_id() will retrieve 726

[Mchl]

Just be careful on multi row inserts. It will return FIRST id that was generated.

[bulrush]

It's not working.

 

I'm using: $dbc = mysqli_connect($host, $user, $password, $database);

 

And:

$partidvar=mysqli_insert_id($dbc); //Get key field of last INSERT statement.

if (strlen($partidvar)==0)

{

        $msg=mysql_error().'Could not get last partid.<br/>'.$query; //There was an error.

        crError($_SERVER['PHP_SELF'].' line '.__LINE__,$msg,true);

}

 

Should I use: mysqli_insert_id($dbc)?

 

[radar]

how i do mine:

 

$sql = "my query";

$data = mysql_query($sql);

$id = mysql_insert_id();

[bulrush]

Thanks! Got it working.  I did have to use the mysqli version.

 

[Mchl]

Just make sure you use mysqli_* functions everywhere. mysql_error() won't work with mysqli connection.