Title: Product Tables
Last modified: August 20, 2016

---

# Product Tables

 *  [RustyFish](https://wordpress.org/support/users/rustyfish/)
 * (@rustyfish)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/product-tables/)
 * Hello, Good Morning, Good Afternoon Everyone,
 * Looking for some advice if I may.
 * I want to create a product table that will be linked to a table created within
   the wordpress database. The tables will be a list of parts, with field such as
   part number, sizes, datasheets (pdf link), etc
 * I had looked at using wp-table reloaded, but I want to keep it easy to update,
   so feel doing the product table directly in the SQL database and using a front
   engine to update it will work best.
 * However, I was wondering what the best way to get the info and tabulate it on
   a page is. Is there a plug, any raw code examples, tutorials etc??
 * Any help would be hugely appreciated
 * Thanks
    Rustyfish

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

 *  Thread Starter [RustyFish](https://wordpress.org/support/users/rustyfish/)
 * (@rustyfish)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/product-tables/#post-3594551)
 * Hi All,
 * Ive actually managed to solve this now using the $wpdb commands straight in to
   my database.
 * However, this leads me on to another question. Within this table is a field for
   a product image. I have set the field as a Varchar, and then added the address
   to this line. Example: /httpdocs/wordpress/wp-content/uploads/images/example.
   png
 * Unfortunately, it does not seem to pick up and show the image, so Im wondering
   if I have done this right?
 * Any help??
 *  Thread Starter [RustyFish](https://wordpress.org/support/users/rustyfish/)
 * (@rustyfish)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/product-tables/#post-3594556)
 * Im struggling to get this to display the image, any ideas??
 * <?php
    global $wpdb; $products = $wpdb->get_results(“SELECT * FROM mydatabase”);
   echo “<table border=1>”; foreach($products as $part_num){ echo “<tr>”; echo “
   <td>”.$part_num->part_num.”</td>”; echo ‘<td> <img src=”.$part_num->image.”> 
   </td>’; echo “</tr>”; } echo “</table>”; ?>

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

The topic ‘Product Tables’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 1 participant
 * Last reply from: [RustyFish](https://wordpress.org/support/users/rustyfish/)
 * Last activity: [13 years, 2 months ago](https://wordpress.org/support/topic/product-tables/#post-3594556)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics