Title: failed to get value from database using shortcode exec PHP
Last modified: August 21, 2016

---

# failed to get value from database using shortcode exec PHP

 *  [nencor](https://wordpress.org/support/users/nencor/)
 * (@nencor)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/failed-to-get-value-from-database-using-shortcode-exec-php/)
 * i have created the following PHP code
 *     ```
       <?php
   
       global $wpdb;
   
       $myrows = $myrows = $wpdb->get_results("SELECT um.meta_value FROM wp_users u, wp_usermeta um
       where u.id = um.user_id and um.meta_key='twitter' and u.user_login='soulartist'");
   
       return str_replace("@","",$myrows);
   
       ?>
       ```
   
 * and when i hit the ‘test’ button, it shows messagebox with
    “[return_twitter]
   =”””
 * when i run the query on phpmyadmin, it returns a single value “@yuliusshandy”
 * where did i go wrong ?
 * thanks !
 * [https://wordpress.org/plugins/shortcode-exec-php/](https://wordpress.org/plugins/shortcode-exec-php/)

The topic ‘failed to get value from database using shortcode exec PHP’ is closed
to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/shortcode-exec-php.svg)
 * [Shortcode Exec PHP](https://wordpress.org/plugins/shortcode-exec-php/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/shortcode-exec-php/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/shortcode-exec-php/)
 * [Active Topics](https://wordpress.org/support/plugin/shortcode-exec-php/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/shortcode-exec-php/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/shortcode-exec-php/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [nencor](https://wordpress.org/support/users/nencor/)
 * Last activity: [12 years, 2 months ago](https://wordpress.org/support/topic/failed-to-get-value-from-database-using-shortcode-exec-php/)
 * Status: not a support question