How can I refer from one variable to hidden variable?

[hjyn]

Hi All,

I have started my php source code shown below

---------------------------------------------------------
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1"))
{
$insertSQL = sprintf("INSERT INTO users (UserID, UserName, Password)
VALUES (%s, %s, %s)",
GetSQLValueString($_POST['UserID'], "int"),
GetSQLValueString($_POST['UserName'], "text"),
GetSQLValueString($_POST['Password'], "text"));

mysql_select_db($database_SHHConnection, $SHHConnection);
$Result1 = mysql_query($insertSQL, $SHHConnection) or
die(mysql_error());
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1"))
{
$insertSQL = sprintf("INSERT INTO holidaymaker (HMID, Name, Status)
VALUES (%s, %s, %s)",
GetSQLValueString($_POST['HMID'], "int"),
GetSQLValueString($_POST['Name'], "text"),
GetSQLValueString($_POST['Status'], "text"));
$HMID = $_POST['users.UserID'];
mysql_select_db($database_SHHConnection, $SHHConnection);
$Result1 = mysql_query($insertSQL, $SHHConnection) or
die(mysql_error());
}

<input type="hidden" name="UserID" value="">
<input type="hidden" name="HMID" value= "Users.UserID">
---------------------------------------------------------

The value for "UserID" is auto_increment by MySql

UserID int(4) auto_increment primary key,

Assume that I want to add new user, the value auto increment for
UserID is 5, I want HMID to be 5 too, which mean HMID refer to UserID.
How can I do that?

Thanks.
Best Regards,
Hjyn