Inserting data after mysql_insert_id();

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

I am trying to find out what type of points were added and add the points details information.

Code:

if($op=="Reenforce") {    





      $rp_id = intval($_POST['rp_id']);


      $rpoint_dt = $_POST['rpoint_dt'];      


      $r_points = intval($_POST['r_points']);


      $team_id = $_POST['team_id'];   


      


      


      //Insert the values into the database


      $result = $db->sql_query ("INSERT INTO " . $prefix . "_eto_rpoints_lkup (pid, rp_id, rpoint_dt, team_id, r_points)".


         "VALUES ('NULL','$rp_id',CURRENT_TIMESTAMP(),'$team_id','$r_points')");


      





//Find out what type of points were added and insert the points details      


      $pid = mysql_insert_id(); 


      if ($rp_id == '1')   {


         $rp_details = 'Added Fuel Reenforcement';


         }


      elseif($rp_id == '2')   {


         $rp_details = 'Added Munition Reenforcement';


         }


      elseif($rp_id == '3')   {


         $rp_details = 'Added Manpower Reenforcement';


         }   


      


      $result = $db->sql_query ("INSERT INTO " . $prefix . "_eto_rpoints_lkup SET   rp_details = '$rp_details' WHERE pid = '$pid'");         


      


}

Posted: Mon Nov 20, 2006 2:11 pm

Disregard.

Should have been an UPDATE and not an INSERT.

Code:

$result = $db->sql_query ("UPDATE " . $prefix . "_eto_rpoints_lkup SET....