[SOLVED] "guessing" next auto_increment number

[itazev]

Hey ya!

Well, i got a table of clients with a field client_id which i set as autonumber.

The problem comes up when a new client is stored in the database: after the record is stored in the table (save.php) i want to redirect the user to the page form layout which will display all just stored information, but to do so i need to know what is that client_id number just stored once it is autonumber. so i can do a "select ... from ... where client_id=???" query

 

Can you give a hand please?

 

Thank you!

[bubblegum.anarchy]

use mysql_insert_id() to get the last insert id

 

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
mysql_select_db('mydb');

mysql_query("INSERT INTO mytable (product) values ('kossu')");
printf("Last inserted record has id %d\n", mysql_insert_id());
?>

[itazev]

Cheers mate! worked very fine!!! 

Thank you bubblegum!

[Wildbug]

You can also use LAST_INSERT_ID() if you want to do it entirely in SQL.

 

SELECT ... FROM ... WHERE client_id=LAST_INSERT_ID()