ghadacr

Thanks for the suggestion, i did the changes and i'm getting the following error: Which is this line: mssql_bind($query, "@ChildOrAdult",$data['ChildAdult'],SQLBIT); it does not like this ['ChildAdult']

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... <?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'; ?>

I got an array that is processing mutiple form elements... When it comes into the process it gets processed by using a stored procedure... But i think i dont have the array setup properly: <?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']; $FlightID = $_GET['FlightID']; $ClientDetailID = $_GET['ClientDetailID']; //----Query 5------ $query = mssql_init ("sp_insertFlightSpaces"); mssql_bind($query, "@FlightID", $FlightID, SQLVARCHAR); mssql_bind($query, "@ClientDetailID", $ClientDetailID, SQLINT2); $data = array('ChildAdult' => array (mssql_bind($query, "@ChildOrAdult", $ChildAdult, SQLVARCHAR)), 'cost' => array (mssql_bind($query, "@cost", $cost, SQLVARCHAR)), 'notes' => array (mssql_bind($query, "@notes", $notes, SQLVARCHAR)), 'title' => array (mssql_bind($query, "@Title", $title, SQLVARCHAR)), 'firstname' => array (mssql_bind($query, "@FirstName", $firstname, SQLVARCHAR)), 'surname' => array mssql_bind(($query, "@Surname", $surname, SQLVARCHAR)); if (($result = mssql_execute($query)) === false) { die('Could not execute the query query 2(Insert client)'); } ///-------------------------------------------- } mssql_close() ?> <?PHP include 'footer.php'; ?> I keep on getting errors such as: Thanks for the help....