[insert_php]
$current_user = wp_get_current_user();
$johnny = $current_user->user_login;
global $wpdb;
foreach( $wpdb->get_results(“SELECT * FROM wp_Customers;”) as $key => $row) {
//each column in your row will be accessible like this
$pancho = $row->UserName;
if($johnny == $pancho ){
echo ‘Your Monthly Payment Is ‘ . $row->MonthlyPaymentAmount;
echo (“\n”);
echo ‘Your total Balance Owed Is ‘,$row->AmountOwed;
echo (“\n”);
echo ‘* There is A 4% fee for using the online Payment System’;
}
}
[/insert_php]