test
[insert_php] echo ‘Server date and time is: ‘; echo date(‘l, F j, Y \a\t G:i:s’); global $wpdb; $table_name = $wpdb->prefix.sudipta_donate_event; echo $table_name; $var = array(); $results = $wpdb->get_results(“SELECT volunteer_name, SUM( donation_amt ) as sum FROM $table_name WHERE paypal_paid = ‘Completed’ GROUP BY volunteer_name”); if ($results) { foreach ( $results as $result ) { $var[$result->volunteer_name] = $result->sum; } } echo $var[‘Chandra Ramasahayam’]; echo $var[‘Harinatha Murukuti’]; echo $var[‘Kiran Adimatyam’]; echo $var[‘Kiran Reddy’]; echo $var[‘Manoj Ravuru’]; echo $var[‘Ritu Agrawal’]; echo $var[‘Siva Agnoor’]; echo $var[‘Sridhar Nukala’]; [/insert_php]