Sometimes you need the ID just before it is generated. Here is a way to do that
$result=mysql_query(“SHOW TABLE STATUS LIKE ‘tablename’ “);
if($result & mysql_num_rows($result))
{
$row=mysql_fetch_assoc($result);
$next_id=$row['Auto_increment'];
}
else
{
die(“error”);
}







02 Jul 2011
Posted by Aals 

