yassernet

I`ve tried to make this function
does it seems to be currect?

function custom_wallet_balance_widget() {
	global $wpdb;

	$sql1 = "SELECT SUM(amount) FROM {$wpdb->prefix}woo_wallet_transactions WHERE type='credit' ";
	$sql2 = "SELECT SUM(amount) FROM {$wpdb->prefix}woo_wallet_transactions WHERE type='debit' ";

	echo '<p>Credits Total: '.$wpdb->get_var( $sql1 ).' </p>';
	echo '<p>Debits Total: '.$wpdb->get_var( $sql2 ).' </p>';
	echo '<p>Balance: '.( $wpdb->get_var( $sql1 ) - $wpdb->get_var( $sql2 ) ).' </p>';
}

• This reply was modified 6 years, 3 months ago by yassernet.