Quiz Start Time:      2018-07-16 17:58:05
Quiz End Time:        2018-07-16 17:53:25
Activity Meta ID:    5979
Obtained Marks:     8
Total Marks:               10

Array
(
    [0] => stdClass Object
        (
            [user_id] => 191
            [secondary_item_id] => 10395
            [meta_value] => 50
            [activity_id] => 9451
            [id] => 9451
        )

    [1] => stdClass Object
        (
            [user_id] => 191
            [secondary_item_id] => 10395
            [meta_value] => 50
            [activity_id] => 9450
            [id] => 9450
        )

    [2] => stdClass Object
        (
            [user_id] => 191
            [secondary_item_id] => 10395
            [meta_value] => 50
            [activity_id] => 9445
            [id] => 9445
        )

    [3] => stdClass Object
        (
            [user_id] => 191
            [secondary_item_id] => 10395
            [meta_value] => 50
            [activity_id] => 6148
            [id] => 6148
        )

    [4] => stdClass Object
        (
            [user_id] => 191
            [secondary_item_id] => 10395
            [meta_value] => 40
            [activity_id] => 5462
            [id] => 5462
        )

)

$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);

top
Copyright © 2004-2017. All right Reserved Misbahudduja University