MySQL field to HTML form

Doozer

I need to place a MySQL DB field which has just been filled by a user and placed in the DB to be passed to a new HTML page, no form fields, just to display the unique ID field.

Process:
User fills in field
User clicks submit
Php script validates data & writes to DB if OK
Unique ID field read from DB
New page displayed with Unique ID.

Any ideas?

lazzerous

<?
if (!isset($submit))
    {
    // form not submitted yet - show form
?>
<form method="post" action="<? echo $PHP_SELF; ?>">
<input type="text" name="user_data">
<input type="submit" name="submit" value="submit">
<?
    }
else
    {
    // process form
    $add_data = "insert into tablename set userData = '$user_data'";
    if (!$do_add_data = mysql_query($add_data))
        {
        echo "Error!";
        die;
        }

 $get_id = "select max(id) from tablename";
 if (!$do_get_id = mysql_query($get_id))
    {
    echo "Error!";
    die;
    }
$row=mysql_fetch_array($do_get_id);
$id = $row[id];

echo "New ID: $id<br>\n";
}
?>

Doozer

Thats pretty slick, and would help my situation if I was using just Php.

I have a html form running an external php script on user click of the submit button.
<form action="script/userDetails.php" method="post" onsubmit="return FrontPage_Form1_Validator(this)" language="JavaScript" name="FrontPage_Form1">

Now, script runs perfectly and I can get the last Autoincrement record using, mysql_insert_id(), however, I cannot get the id to pass within the script with

header ("Location: $formSuccess");

where $formSuccess = "../responses/formSuccess.htm?id="; is defined as the start of the script.
What do I need to include in the above line to enable me to display the id on the new page?