* @param [type] $flight_id [description]
* @return [type] [description]
*/
-function nb_booked($client_id, $flight_id)
+function nb_booked($client_id, $flight_id, $class_name)
{
global $connection;
- $sql_pquery = "select SUM(NbPlaces) from RESERVATIONS where NumCl = ? and NumVol = ?";
+ $sql_pquery = "select sum(NbPlaces) from RESERVATIONS where NumCl = ? and NumVol = ? and Classe = ?";
$connection->prepare_query($sql_pquery);
- $connection->prepared_query_bind_param("is", array($client_id, $flight_id));
+ $connection->prepared_query_bind_param("iss", array($client_id, $flight_id, $class_name));
$connection->run_prepared_query();
$connection->get_pquery_result();
$row = $connection->get_result_array();