redirecting to the ID of newest item created

[envexlabs]

Hey,

 

I have a form that a user submits which creates a product.

 

I want the user to be redirected to product.php?product_i=(the new product id)

 

The problem i'm having is that i dont know the ID of the new product created because the table is set to auto increment.

 

How would i go about finding out the new ID and redirecting to that new product after it has just been created?

 

Thanks,

 

envex

[HuggieBear]

If you're using MySQL then make your insert using mysql_query() and then straight after, use mysql_insert_id() 

 

<?php
if ($r = mysql_query("INSERT INTO product_table VALUES ('something','something')")){
   header('Location: product.php?product_id=' . mysql_insert_id($r));
}
?>

 

Regards

Huggie