Title: bdev9's Replies | WordPress.org

---

# bdev9

  [  ](https://wordpress.org/support/users/bdev9/)

 *   [Profile](https://wordpress.org/support/users/bdev9/)
 *   [Topics Started](https://wordpress.org/support/users/bdev9/topics/)
 *   [Replies Created](https://wordpress.org/support/users/bdev9/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/bdev9/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/bdev9/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/bdev9/engagements/)
 *   [Favorites](https://wordpress.org/support/users/bdev9/favorites/)

 Search replies:

## Forum Replies Created

Viewing 1 replies (of 1 total)

 *   Forum: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
   
   In reply to: [querying and displaying post meta data multidementional array](https://wordpress.org/support/topic/querying-and-displaying-post-meta-data-multidementional-array/)
 *  Thread Starter [bdev9](https://wordpress.org/support/users/bdev9/)
 * (@bdev9)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/querying-and-displaying-post-meta-data-multidementional-array/#post-4671071)
 * It took me a while to get the syntax, but once I found out there was a function
   to unserialize the variable it was much easier.
 *     ```
       global $wpdb;
   
       //Define the WordPress post meta table
       $metatable = $wpdb->prefix."postmeta";
   
       //Retrieve post_id of every business page
       $post_id_business=$post->ID;
   
       //Formulate the SQL query
       //Using prepared statements is the correct method
       //You should be using this for security reasons
       //Use $wpdb->get_var for retrieving single result
       $business_hours = $wpdb->get_var($wpdb->prepare("SELECT meta_value FROM $metatable where post_id=%d AND meta_key='_wppl_days_hours'",$post_id_business));
   
       //Output the hours to your theme
       //Simple echo the variable directly containing the result query
       //echo $business_hours;
   
       $a = unserialize($business_hours);
       //print_r($a);
   
       echo "<br>";
       for ($row = 0; $row < 7; $row++)
       {
        echo $a[$row][days].": ".$a[$row][hours]."<br>";
       }
       //var_dump($a);
       ```
   
 * So in a nutshell it works:
 *     ```
       Hours:
       Sunday: 11am-10pm
       Monday: Closed
       Tuesday: 11am-12am
       Wednseday: 11am-12am
       Thursday: 11am-12am
       Friday: 11am-2am
       Saturday: 11am-2am
       ```
   

Viewing 1 replies (of 1 total)