if (mysqli_query($con, $sql))
    {
        $sql2 = "SELECT rate AS amount, COUNT(*) AS passenger_no FROM `payment_details` WHERE number_plate = '$number_plate'";

    }
        $ress = mysqli_query($con, $sql2);
        if($row = mysqli_fetch_array($ress))
        {
            $amount = $row['amount'];
            $passenger_no = $row['passenger_no'];

            switch($type)
            {
                case "Fare":
                    $sql3 = "INSERT INTO fare (number_plate, amount, passenger_no) VALUES ('$number_plate', '$amount', '$passenger_no')";
                    break;
                case "Courier":
                    $sql3 = "INSERT INTO courier (number_plate, amount) VALUES ('$number_plate', '$amount')";
                    break;

            }

            if(mysqli_query($con, $sql3))
            {

            }