dupdb.php

$pay = 'Full Payment';
$result = $con->query( $sql );
while ( $row = $result->fetch_assoc() ) {
	if( $row['sm_pay'] == 'Split Payment' ) {
		$pay = 'Split Payment';
	}
}

$result = $con->query( $sql );
while ( $row = $result->fetch_assoc() ) {
	$ek = strtolower( $row['email'] );
	if ( ! array_key_exists( $ek, $orders ) ) {
		$orders[ $ek ] = array();
		$orders[ $ek ]['items'] = array();
	}
	$orders[ $ek ]['items'][$cnt]['total'] = calc_total( $pay );
	$cnt++;
}

$pay = 'Full Payment';
$result = $con->query( $sql );
while ( $row = $result->fetch_assoc() ) {
    if( $row['sm_pay'] == 'Split Payment' ) {
        $pay = 'Split Payment';
    }
//}

//$result = $con->query( $sql );
//while ( $row = $result->fetch_assoc() ) {
    $ek = strtolower( $row['email'] );
    if ( ! array_key_exists( $ek, $orders ) ) {
        $orders[ $ek ] = array();
        $orders[ $ek ]['items'] = array();
    }
    $orders[ $ek ]['items'][$cnt]['total'] = calc_total( $pay );
    $cnt++;
}