Title: PHP variable in SQL select issues
Last modified: February 26, 2020

---

# PHP variable in SQL select issues

 *  Resolved [user70](https://wordpress.org/support/users/user70/)
 * (@user70)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/php-variable-in-sql-select-issues/)
 * Probably a general coding issue and not specific to the plugin.
    I have the following
   snippet, but for some reason user_id = $current_user_id is ot working. If I use
   a known ID for user_id it works correctly. I’m still very green, can anyone kindly
   point out what I’m doing wrong?
 *     ```
       function fetch_member_id(){
       	$current_user = wp_get_current_user();
       	$current_user_id = $current_user->ID;
       	global $wpdb;
       	$result = $wpdb->get_results('SELECT meta_value FROM usermeta WHERE meta_key = \'random_number\' AND user_id = $current_user_id');
       	foreach($result as $row){
       		return 'Membership ID: '. $row->meta_value;		
       	}
       }
       ```
   
    -  This topic was modified 6 years, 3 months ago by [user70](https://wordpress.org/support/users/user70/).

Viewing 1 replies (of 1 total)

 *  Thread Starter [user70](https://wordpress.org/support/users/user70/)
 * (@user70)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/php-variable-in-sql-select-issues/#post-12484784)
 * Never mind, this fixed it:
 *     ```
       function fetch_member_id(){
       	$current_user = wp_get_current_user();
       	$current_user_id = $current_user->ID;
       	global $wpdb;
       	$result = $wpdb->get_results('SELECT meta_value FROM usermeta WHERE meta_key = \'random_number\' AND user_id = ' . $current_user->ID);
       	foreach($result as $row){
       		return 'Membership ID: '. $row->meta_value;		
       	}
       }
       ```
   
    -  This reply was modified 6 years, 3 months ago by [user70](https://wordpress.org/support/users/user70/).

Viewing 1 replies (of 1 total)

The topic ‘PHP variable in SQL select issues’ is closed to new replies.

 * ![](https://ps.w.org/code-snippets/assets/icon.svg?rev=2148878)
 * [Code Snippets](https://wordpress.org/plugins/code-snippets/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/code-snippets/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/code-snippets/)
 * [Active Topics](https://wordpress.org/support/plugin/code-snippets/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/code-snippets/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/code-snippets/reviews/)

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [php](https://wordpress.org/support/topic-tag/php/)

 * 1 reply
 * 1 participant
 * Last reply from: [user70](https://wordpress.org/support/users/user70/)
 * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/php-variable-in-sql-select-issues/#post-12484784)
 * Status: resolved