Title: Help with creating short code
Last modified: August 22, 2016

---

# Help with creating short code

 *  Resolved [Sumo1](https://wordpress.org/support/users/sumo1/)
 * (@sumo1)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/help-with-creating-short-code/)
 * Hi,
 * I’m trying to create short code to use in the wordpress admin content editors.
   Not sure if I’m using the correct row in the db, and I can’t find anything in
   your documentation showing where the data is inserted in wpdb.
 * So far I have this, but it’s not working:
 *     ```
       $results = $wpdb->get_row($sql,ARRAY_A);
             $surfschool_name = $results['display_name'];
             $surfschool_email = $results['user_email'];
             $surfschool_logo = $results['author_image'];
       ```
   
 * Then I’m using an array like this:
 *     ```
       array(
            'surfschool' => $surfschool_name,
            'surfschoolemail' => $surfschool_email,
            'surfschoollogo' => $surfschool_logo
             )
       ```
   
 * Both `[surf school]` and `[surfschoolemail]` work perfectly as short code but`[
   surfschoollogo]` does not.
 * Have you got any suggestions?
 * Thanks
 * [https://wordpress.org/plugins/sem-author-image/](https://wordpress.org/plugins/sem-author-image/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Mike Koepke](https://wordpress.org/support/users/mike_koepke/)
 * (@mike_koepke)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/help-with-creating-short-code/#post-5641293)
 * The plugin does not use the database for the image location. Instead it uses 
   a uses a folder in wp-content and checks for the existance of an image file for
   the given author.
 *  Thread Starter [Sumo1](https://wordpress.org/support/users/sumo1/)
 * (@sumo1)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/help-with-creating-short-code/#post-5641298)
 * Actually it does, I worked it out. This returns the file name.
 *     ```
       $sql_author_image = "SELECT meta_value FROM wp_usermeta WHERE user_id =  $user_id AND meta_key = 'author_image' ";
   
       $author_image = $wpdb->get_var($sql_author_image);
       ```
   
 * Then all you have to do is create an `add_shortcode` function.
 *  Plugin Author [Mike Koepke](https://wordpress.org/support/users/mike_koepke/)
 * (@mike_koepke)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/help-with-creating-short-code/#post-5641424)
 * 4.9 version supports [author-image] shortcode for displaying in th epost/page
   content.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Help with creating short code’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/sem-author-image.svg)
 * [Author Image](https://wordpress.org/plugins/sem-author-image/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/sem-author-image/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/sem-author-image/)
 * [Active Topics](https://wordpress.org/support/plugin/sem-author-image/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/sem-author-image/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/sem-author-image/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Mike Koepke](https://wordpress.org/support/users/mike_koepke/)
 * Last activity: [10 years, 9 months ago](https://wordpress.org/support/topic/help-with-creating-short-code/#post-5641424)
 * Status: resolved