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]