Display column values from database

Question

Hi. I'm trying to display all the values from a specific column created by my Wordpress plugin (specifically, the ID's). Here is the code I have managed to use to display the column names, but I cannot get it to just display all the ID's. Here is the code:

function test() {
    global $wpdb;
    global $table_name;
    $testing = $wpdb->get_col_info('name', 0);
    foreach ($testing as $test) {
      echo $test;
    }
}

And here you can see the output:

www.matthewruddy.com/premiumslider

Can anyone help me out?

Answer 1

It seems you want data instead of column information. So you need to another function.

$testing = $wpdb->get_results("SELECT id FROM mytable")
foreach ($testing as $test) {
    echo $test->id
}

---

EDIT:

OK, how about this one:

$wpdb->show_errors();
echo 'Listing from table: $table_name<br>';
$ids = $wpdb->get_col($wpdb->prepare("SELECT id FROM %s", $table_name));
if ($ids) {
  echo 'printing results:<br>';
  foreach($ids as $id) {
    echo $id;
  }
} else {
  echo 'no results or error<br>';
  echo 'error: ' . $wpdb->print_error();
}
$wpdb->hide_errors();

If this doesn't help you either to get your ID's or to figure out what the error is, I am lost.