Show Next Auto Increment For Table

[ShoeLace1291]

Is there a way to show the next auto increment like in PHPMyAdmin for a certain table?

[Barand]

The only time you will need it is when you insert a new record in one table and then insert linked records into a child table.

 

insert parent record.

call mysql_insert_id() to get its id

insert child records with value returned by the function as foreign key

[MadTechie]

maybe

SELECT MAX(id) FROM table

unless the last one was deleted!

 

may i ask why ?

 

surely your use mysql_insert_id

int mysql_insert_id ( [resource $link_identifier] )

 

Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.

[Barand]

MadTechie,

 

mysql_insert_id() - Got that one covered

[sasa]

<?php
mysql_connect('localhost');
mysql_select_db('test');
$table_name = 'matches'; //change to your table name
$sql = "SHOW TABLE STATUS LIKE '$table_name'";
$res = mysql_query($sql) or die(mysql_error());
$r = mysql_fetch_array($res);
echo 'Next auto increment number for table ', $table_name, ' is ', $r['Auto_increment'];
?>

[ShoeLace1291]

The only time you will need it is when you insert a new record in one table and then insert linked records into a child table.

 

insert parent record.

call mysql_insert_id() to get its id

insert child records with value returned by the function as foreign key

 

Actually I need it to redirect my users to a thread or poll they just created in the same page.

[MadTechie]

if they just created it, then when you create it use mysql_insert_id() to get the id, and pass that!