Get next auto_increment value in mysql

[sourcecode language=”php”]
<?php
SHOW TABLE STATUS LIKE ‘$tablename’;
ehco mysql_result($query, 0, ‘Auto_increment ‘);
?>
[/sourcecode]