--- Stuart Felenstein <stuart4m@xxxxxxxxx> wrote: > I know recently the server was update from PHP 4.3.8 > to 4.3.9 but that shouldn't have effected anything. > > Code: > > $query = "INSERT INTO table1 (ProfileID, LurkID, > ProfileName, Edu,..................." > VALUES (null,......................." > > ProfileID is the PrimaryID (autoinc) - I've set the > input value to null for the auto-inc to properly > work. > I assume this is correct and it did work at one > time. > > Then before the next query: > > $LID = mysql_insert_id(); > > Then each subsequent query uses $LID in the > subsequent > tables. > > However $LID is now returning 0 and the transaction > fails. > > At the end of the transaction I follow through with > this: > > //resx = all the queries > if($res1 && $res2 && $res3 && $res4 && $res5 && > $res6 > && res7 ) // If all results are true > { > commit(); > //echo "your insertions were successful"; > unset($all session variable, $LID, ); > > }else{ > > ................... > > Puzzling since this script was working great. We did > also upgrad MySQL from 4.0.21 to 4.0.22-standard > I wanted to add - I realize that if there is an error in the first query (where the id is generated) it would result in a value of 0 I've echoed out the query and am seeing this: "Duplicate entry '0-i' for key 1 transaction failed" Never seen a 0-i before. Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php