mysql_insert_id help

Question

$position .= mysql_insert_id();

$sql = "UPDATE ".$this->table_name."
     SET position = '".$position."'
     WHERE id = '".mysql_insert_id()."'";

When i return $position i get two values 150 and 151. That is current row ID and previous or selected row ID. I just need the previous ROW ID.When i look into my DB i have two values 150151.

This is actually of parent child relationship.

Answer 1

you just need the previous one (151) ?

then all you have to do is throw away the concatenation operator (.)

$position = mysql_insert_id(); // you get 151

or if you want the 150 , just leave the $position alone :

// $position .= mysql_insert_id();
echo $position; // you get 150

or did I get that wrong ?