auto_increment

[treeleaf20]

I'm inserting a record into the database and the id field is incrementing using auto_increment. My problem is that as soon as I insert a field I want to use the id that was just assigned to that row.

My only thought is to do a look up on the MAX number, but I'm worried that someone might insert another record before the second query is run to get the max number and thus I wouldn't get the correct data.

Any thoughts on how to do this?

Thanks.

[laserlight]

You could use something along the lines of PDO::lastInsertId(), [man]mysql_insert_id/man, [man]mysqli_insert_id/man, [man]pg_last_oid/man, [man]sqlite_last_insert_rowid/man, etc.

[hutchic]

		$sql = "SELECT id FROM $table order by id desc limit 1";
		$id = 0;
		$result = mysql_query($sql);
		if($result!=null){
			$row = mysql_fetch_array($result, MYSQL_ASSOC);
			$id = $row["id"]+1;
		}
		$sql = "INSERT into $table (id, $fieldList) VALUES($id, $values)";

afterwards $id contains the number you're looking for

[laserlight]

afterwards $id contains the number you're looking for

Not necessarily, since the auto increment algorithm used could have designated the id of a previously deleted row as the next id to assign.