Passing form variable values to another php script

limey

I am having problems passing html form variable values to another php script that takes these values to use in SQL scripts. Could somebody help me out ?

Here's some code snippets:

Script with form frontend

<FORM ACTION="Booking.php?forename?>" METHOD=post>
<input name="submit" type="submit" id="submit2" value="Proceed">
</form>

script that executes SQL statement

$forename = forename; //variable passed from other form

//SQL statement
"insert into tblcustomers (customer_forename, customer_surname, customer_telephone, customer_email)
values ('".$forename."', '".$surname."', '".$telephone."', '".$email."')"

laserlight

<form action="booking.php" method="post">
<input type="text" name="forename" id="forename" size="30" />
<input type="submit" name="submit" id="submit2" value="Proceed" />
</form>

if (isset($_POST['forename'])) {
	$forename = $_POST['forename']; //variable passed from other form
	//you will have to consider $surname, $telephone and $email as well
	$query = "INSERT INTO `tblcustomers`
		(`customer_forename`, `customer_surname`, `customer_telephone`, `customer_email`)
		VALUES ('{$forename}', '{$surname}', '{$telephone}', '{$email}')"
	//now run the query
}
else {
	//some error message
}

limey

I have been having a lot of trouble posting SQL statements to the database, now I know why, my syntax was incorrect. The passed variables where visible after all.

Cheers
limey