Getting the latest id from autoincrement field

SFDonovan

Here is what I am trying to do.

//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

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

Any assistance is appreciated.

cgraz

I think you're looking for mysql_insert_id()

HTH

SFDonovan

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

cgraz

The parameter for mysql_insert_id is actually in your case $result, because that's where you ran the insert query. But it looks as if that is optional, so you could probably get away with something like this

$result = mysql_query("INSERT INTO your_table...etc") or die(mysql_error());

// Do whatever you want with your query here

// Grab ID
$id = mysql_insert_id();    

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

Let me know how that works out for you.