WPDB

$myrows will be an array. You can dump it out with print_r($myrows) to see what is in it.

Your query is not coded correctly. The word ‘OBJECT’ should not be inside the quotes.

Besides that, unless ‘hotels’ is a table that you created outside of WordPress, there will not be a table by that name. Please explain what you are trying to do so the proper query can be determined.

Especially explain if ‘hotels’ is a Category, a Custom Post type, or something else.

To print things from the array, you use a foreach loop, something like this:

$myrows = $wpdb->get_results( "SELECT * FROM $wpdb->posts WHERE post_type = 'parks'", OBJECT);
//print_r($myrows);
global $post;
foreach ( $myrows as $post ) {
   setup_postdata($post);
   echo "<p>TITLE:"; the_title(); echo "</p>";
}

Thank you for your reply. I really appreciate it.

Okay So I have a list of hotels in the area in the database in a table called hotels.

I want to be able to call out the hotels that are in the table and display them on a wordpress page.

Each hotel has an id, name, address, cost and picture. I want to display it in a table format too.

Thanks again.

I can’t test this as I have no ‘hotels’ table in my test database, so it may require some changes.

$myrows = $wpdb->get_results( 'SELECT * FROM hotels', OBJECT);
//print_r($myrows);
if ($myrows) {
   foreach ( $myrows as $hotel ) {
      echo "<p>ID:$hotel->id NAME:$hotel->name COST:$hotel->cost</p>";
   }
}

I leave the formatting of the output up to you.

If you don’t get any output, uncomment the print_r() line to see if you are getting any results.

Thank you so much, You are an absolutely angel. Its works fantastically.