MySQL Query not working…

  • mrdthomas

    (@mrdthomas)


    14 years, 8 months ago

    I have successfully inserted data into a custom table using the method in the Function Reference but now I am having a problem retrieving the data and displaying it in a template page.

    Here is the code that I used.

    <?php
$x =  $wpdb->get_results("SELECT * FROM $wpdb->custom_table");

foreach ($x as $y) {
echo $y;
}
$wpdb->show_errors();
?>

    I get no results from this query just a blank page… Am I doing something wrong?

    Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • esmi

    (@esmi)

    14 years, 8 months ago

    Have you tried just using:

    $x = $wpdb->get_results("SELECT * FROM custom_table");

    Thread Starter mrdthomas

    (@mrdthomas)

    14 years, 8 months ago

    I tried that and I get

    Catchable fatal error: Object of class stdClass could not be converted to string in /path/to/file on line 50

    Any other ideas?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL Query not working…’ is closed to new replies.