Need to find the autoincrement id of latest record.

Client Joined: Oct 07, 2003 Posts: 735 Location: Ohio

Here is what I am trying to do.

Code:

//Insert the values into the correct database with the right fields


   $result = $db->sql_query ("INSERT INTO " . $prefix . "_milpacs_members (uniqueid, u_name, uniform, rank_id, flag, location, status, p_mos, unit_id,  reports, position, weapon_id, enlistment_dt, icq, bio)".


      "VALUES ('NULL','$soldierName','$uniform', $rank_id, '$flag', '$location', '$status', '$p_mos', $unit_id, '$reports', '$position', $weapon_id, '$enlistment_dt', '$icq', '$bio')");





   if (!$result) {


       echo("<p>Error adding Soldier!" . mysql_error() . "</p>");


   }


   else {


      $result = $db->sql_query($sql);


      $id = $db->sql_query ("SELECT max(uniqueid) FROM " . $prefix . "_milpacs_members");


      Header("Location: /milpacs.php?aop=editsoldier&uniqueid=$id");


      


   }

I add the latest record in this table then I want the page to direct to the editsoldier page to add other information. I need to use the id assigned to this record I just added. This doesn't work right now. My url says

Quote:

?aop=editsoldier&uniqueid=Resource%20id%20#167

Any assistance is appreciated.

registered · Posted: Sat Jan 14, 2006 2:09 pm

Donovan, this has been addressed before by Raven, I think in the mySQL Forum, but cannot remember exactly. He gives a sample SQL statement. However, what happens if you change it to this:

$row = $db->sql_query ("SELECT max(uniqueid) as uniqueid FROM " . $prefix . "_milpacs_members");
$id = $row['uniqueid'];

Posted: Sat Jan 14, 2006 5:55 pm

What I did was:

Code:

// Grab ID 


      $id = mysql_insert_id();            


      Header("Location: /milpacs.php?aop=editsoldier&id=".$id);

Works fine.

Posted: Sat Jan 14, 2006 7:32 pm

Donovan, very cool! Thank you for sharing that one. I had never used that before.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

The mysql_insert_id(); is the prefered/best way. The other code was being used, if I remember right, for a field that was not an auto-increment field and therefore the mysql_insert_id(); would not work.