0

I have just created a custom database table and would now like to output every inserted row from it into a predefined format using a foreach statement.

Some guidance in this matter would be great.

Thanks, Ashley

1

Assuming you have table that's prefixed with the WordPress prefix (even if it's not the default one), and the table is called table. Then the following code should select everything, and allow you to go through each row. In this example, it goes through each row and outputs the content of the field foobar.

global $wpdb;
$results = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."table");
foreach ( $results as $row ) 
{
    echo $row->foobar;
};

See the Codex page on $wdpb

0

Use the wpdb class with something like:

global $wpdb;

$results = $wpdb->get_results("SELECT * FROM [custom table name] WHERE key = 'value'");

foreach( $results as $r ) {

    echo $r->field_name;

}
0

Thanks to Rutwick Gangurde, I found out how to do it.

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

foreach ( $mylistitems as $mylistitem ) 
{
echo $currency->somefield;
}
?>

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.