MySQL: Get Next Auto_increment

<?
$tablename         = "tablename";
$next_increment     = 0;
$qShowStatus         = "SHOW TABLE STATUS LIKE '$tablename'";
$qShowStatusResult     = mysql_query($qShowStatus) or die ( "Query failed: " . mysql_error() . "<br/>" . $qShowStatus );

$row = mysql_fetch_assoc($qShowStatusResult);
$next_increment = $row['Auto_increment'];

echo "next increment number: [$next_increment]";
?>