Display data from custom table

<?php
global $wpdb;
// this adds the prefix which is set by the user upon instillation of wordpress
$table_name = $wpdb->prefix . “form”;
// this will get the data from your table
$retrieve_data = $wpdb->get_results( “SELECT * FROM $table_name” );

foreach ($retrieve_data as $retrieved_data){ ?>
<div class=”my-table”>
<ul>
<li><?php echo $retrieved_data->fname;?></li>
<li><?php echo $retrieved_data->email;?></li>
<li><?php echo $retrieved_data->message;?></li>
</ul>
</div>
<?php } ?>

Advertisements

Tagged:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: