FOR each help.....
Posted: Fri Aug 03, 2007 4:42 am
The below for each is not working as its not inserting the code into the database, i'm not sure what to do help please...
Code: Select all
<?PHP include 'opendb.php'; ?>
<?PHP include 'header.php'; ?>
<?php
$title = $_GET['title'];
$firstname = $_GET['firstname'];
$surname = $_GET['surname'];
$ChildAdult = $_GET['ChildAdult'];
$cost = $_GET['cost'];
$notes = $_GET['notes'];
$flight = $_GET['flight'];
$client = $_GET['client'];
foreach ($_GET as $index => $key)
{
$query = mssql_init ("sp_insertFlightSpaces");
mssql_bind($query, "@FlightID", $flight, SQLVARCHAR);
mssql_bind($query, "@ClientDetailID", $client, SQLINT2);
mssql_bind($query, "@ChildOrAdult", $data[$index][3], SQLBIT);
mssql_bind($query, "@Notes", $data[$index][4], SQLVARCHAR);
mssql_bind($query, "@Title", $data[$index][0], SQLVARCHAR);
mssql_bind($query, "@FirstName", $data[$index][1], SQLVARCHAR);
mssql_bind($query, "@Surname", $data[$index][2], SQLVARCHAR);
if (($result = mssql_execute($query)) === false)
{
die('Could not execute the query query 2(Insert client)');
}
///--------------------------------------------
}
//}
//}
//mssql_bind($query, "@cost", $data[$index][4], SQLVARCHAR);
mssql_close()
?>
<?PHP include 'footer.php'; ?>