• I created a new table within my WordPress database called wp_my_table. Then I populated the table with a few rows. I did all this from myphpadmin.

    I am trying to display data from the new table on a page using the EXEC PHP plugin.
    First thing I did was test if the table exists using the following.

    global $wpdb;
    $table_name = $wpdb->prefix . “my_table”;
    if ( $wpdb->get_var(‘SHOW TABLES LIKE ‘ . $table_name) != $table_name ){some random outputs}
    This helped determine that the table exists and is recognized from the page on which I want to display the data.
    Then I went to display something from the new table using the following:

    global $wpdb;
    $table_name = $wpdb->prefix . “my_table”;

    $result = $wpdb->get_results(“SELECT * FROM $table_name”);
    foreach ($result as $theresults) {
    $tableid = $theresults->id;
    echo $tableid;
    }

    For some reason it was not working. At this point I tried to output the size of the $result.

    $sizeofresult = sizeof($result);
    echo $sizeofresult;
    This returned zero. Seems that it is recognizing the table but not the populated rows within the table. When I try all of the above with wp_posts it works fine.
    Not sure what the problem is with the new table. Any help would be greatly appreciated.
    Thanks!

Viewing 1 replies (of 1 total)
  • Thread Starter wpDom3

    (@wpdom3)

    not sure if maybe the table has to be declared somewhere else as well or something along those lines.

Viewing 1 replies (of 1 total)
  • The topic ‘custom table problem’ is closed to new replies.