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]