• Resolved fontener

    (@fontener)


    when i run method wpdb->get_results i get an multi-dimensional array with 4 copies of each result.

    i.e. $metavalues = $wpdb->get_results("SELECT user_id, meta_key, meta_value FROM $wpdb->usermeta WHERE user_id IN ($list)"); run in the function get_user_metavalues()

    if i passed it array(1,2) .. it would return the following 4 times..

    Array ( [1] => Array ( [0] => stdClass Object ( [user_id] => [meta_key] => [meta_value] => ) [1] => stdClass Object ( [user_id] => [meta_key] => last_name [meta_value] => ) [2] => stdClass Object ( [user_id] => 1 [meta_key] => nickname [meta_value] => ) [3] => stdClass Object ( [user_id] => 1 [meta_key] => description [meta_value] => ) [4] => stdClass Object ( [user_id] => [meta_key] => rich_editing [meta_value] => ) [5] => stdClass Object ( [user_id] => 1 [meta_key] => comment_shortcuts [meta_value] => ) [6] => stdClass Object ( [user_id] => [meta_key] => admin_color [meta_value] => ) [7] => stdClass Object ( [user_id] => 1 [meta_key] => use_ssl [meta_value] => ) [8] => stdClass Object ( [user_id] => 1 [meta_key] => aim [meta_value] => ) [9] => stdClass Object ( [user_id] => [meta_key] => yim [meta_value] => ) [10] => stdClass Object ( [user_id] => 1 [meta_key] => jabber [meta_value] => ) [11] => stdClass Object ( [user_id] => [meta_key] => wp_capabilities [meta_value] => ) [12] => stdClass Object ( [user_id] => [meta_key] => wp_user_level [meta_value] => ) [13] => stdClass Object ( [user_id] => 1 [meta_key] => wp_dashboard_quick_press_last_post_id [meta_value] => ) [14] => stdClass Object ( [user_id] => [meta_key] => wp_user-settings [meta_value] =>
    ) [15] => stdClass Object ( [user_id] => [meta_key] => wp_user-settings-time [meta_value] => 1295582622 ) [16] => stdClass Object ( [user_id] => [meta_key] => managenav-menuscolumnshidden [meta_value] => ) [17] => stdClass Object ( [user_id] => [meta_key] => metaboxhidden_nav-menus [meta_value] => ) [18] => stdClass Object ( [user_id] => 1 [meta_key] => managestation-managercolumnshidden [meta_value] => ) [19] => stdClass Object ( [user_id] => 1 [meta_key] => managestation-managercolumnshidden [meta_value] => ) [20] => stdClass Object ( [user_id] => 1 [meta_key] => manageedit-postcolumnshidden [meta_value] => ) [21] => stdClass Object ( [user_id] => [meta_key] => manageuserscolumnshidden [meta_value] => ) [22] => stdClass Object ( [user_id] => [meta_key] => meta-box-order_dashboard [meta_value] => ) [23] => stdClass Object ( [user_id] => [meta_key] => screen_layout_dashboard [meta_value] => ) [24] => stdClass Object ( [user_id] => [meta_key] => closedpostboxes_dashboard [meta_value] => ) [25] => stdClass Object ( [user_id] => [meta_key] => metaboxhidden_dashboard [meta_value] => ) ) [2] => Array ( ) )

The topic ‘problem with wpdb->get_results’ is closed to new replies.