[insert_php]

global $wpdb;
$result = $wpdb->get_results( "SELECT * from `wp_bp_activity` WHERE `user_id` = 158 AND `secondary_item_id` = 15712 ORDER BY `wp_bp_activity`.`id` DESC”);

$starttime = $result[0]->date_recorded;
$metaid = $result[1]->id;
$endtime = $result[2]->date_recorded;

echo "Quiz Start Time:      ".$starttime. "
". "Quiz End Time:        ".$endtime . "
". ” Activity Meta ID:    ". $metaid. "";

$result1 = $wpdb->get_results( "SELECT * FROM `wp_bp_activity_meta` WHERE `activity_id`= $metaid ");

$quizdetails = $result1[2]->meta_value;

$quizd = (unserialize($quizdetails));

echo "
Obtained Marks:     ". $quizd[user_marks]. "";
echo "
Total Marks:               ". $quizd[total_marks]. "";

$result5 = $wpdb->get_results( "SELECT wp_bp_activity.user_id, wp_bp_activity.secondary_item_id, wp_bp_activity_meta.meta_value, wp_bp_activity_meta.activity_id, wp_bp_activity.id
FROM wp_bp_activity, wp_bp_activity_meta

WHERE wp_bp_activity.id=wp_bp_activity_meta.activity_id AND wp_bp_activity.secondary_item_id = 10395 AND `user_id` = 191 AND wp_bp_activity_meta.meta_key = ‘percentage’

ORDER BY CAST(meta_value AS UNSIGNED) desc , wp_bp_activity.id DESC”);

echo ‘

';
   print_r($result5);
   echo  '

‘;

[/insert_php]

$result5 = $wpdb->get_results("SELECT meta_key as user_id, meta_value as marks FROM wp_postmeta WHERE meta_key REGEXP ‘^[0-9]+$’ AND post_id = %d ORDER BY CAST(meta_value AS DECIMAL(10,2)) DESC LIMIT 0,%d”,3504,10);