} else {
$msg = "No results found";
echo display_menu($msg);
}
} else {
$msg = "Error; Not Enough Information";
echo display_menu($msg);
}
} elseif ($_REQUEST[action] == "view_subscription") {
$ss_subscription_ID = quote_smart($_REQUEST[ss_subscription_ID]);
if ($_SESSION['no_more_where'] != "true") {
$where = $_SESSION['where'] . " AND sub.`ss_subscription_ID` = '{$ss_subscription_ID}'";
} else {
$where = $_SESSION['where'];
}
$results = $lookup->find_transaction_query($where);
// $row=mysql_fetch_array($results);
foreach ($results as $outer_key => $row) {
$_SESSION['no_more_where'] = "true";
$report_data["Customer Information"]["Name"] = $row['name'] . " " . $row['surname'];
$report_data['Customer Information']['Address'] = $row['address'];
$report_data['Customer Information']['Phone'] = $row['phonenumber'];
$report_data['Payment Information']['Name on billing statement'] = $row['bankname'];
$report_data['Payment Information']['Last Billing'] = date('l F d, Y', strtotime($row['ss_last_rebill']));
$report_data['Payment Information']['First Billing'] = date('l F d, Y', strtotime($row['ss_account_start_date']));
if (strlen($row[td_username]) > 0) {
$report_data['Subscription Information']['Username'] = $row[td_username];
$report_data['Subscription Information']['Password'] = $row[td_password];
}
$report_data['Subscription Information']['Status'] = $row[ss_rebill_status];
if (strlen($row[td_username]) > 0) {
