Array confusion....

[ghadacr]

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:

 

Parse error: syntax error, unexpected T_STRING, expecting '(' in C:\ line 34

 

Thanks for the help....

[wildteen88]

This line:

'surname' => array mssql_bind(($query, "@Surname", $surname, SQLVARCHAR));

Needs to be

'surname' => array (mssql_bind($query, "@Surname", $surname, SQLVARCHAR)));

 

You had your braces in the wrong placeand you forgot to add a closing ) brace for the parent array