Title: Looking for suggestions for creating basic database
Last modified: August 22, 2016

---

# Looking for suggestions for creating basic database

 *  Resolved [superoctave](https://wordpress.org/support/users/superoctave/)
 * (@superoctave)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/looking-for-suggestions-for-creating-basic-database-help/)
 * Hi there!
 * I’m working on creating a basic database for a theatre and really need some suggestions
   as the best way to approach this.
 * Each production from this theatre will have its own page. The page should display
   who was in the production, displayed in a table. This information is “set”, and
   doesn’t need to change dynamically, though it would be nice to be able to display
   a thumbnail image for each actor (and display a default blank image if no headshot
   is available). I would like the user to be able to click on an actor’s name to
   display a list of other productions that the actor has been involved in.
 * Here’s a picture to give an idea:
    [http://www.matthewjpool.com/images/theatredatabase.jpg](http://www.matthewjpool.com/images/theatredatabase.jpg)
 * For an idea of how the site might function, it should be similar to [ibdb.com](http://www.ibdb.com/)
   or [playbillvault.com](http://www.playbillvault.com)
 * My idea:
 * **Create custom taxonomy** for each actor. Add custom meta field to new taxonomy
   for headshot image.
 * **Store info for each production in a CSV file** and use PHP to generate an HTML
   table when the page loads. Use PHP to grab meta information about each actor 
   and display headshot image.
 * Can anyone give me any feedback as to whether there is an easier or better way
   of approaching this? Any feedback would be strongly welcomed!

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

 *  [WPyogi](https://wordpress.org/support/users/wpyogi/)
 * (@wpyogi)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/looking-for-suggestions-for-creating-basic-database-help/#post-5680780)
 * Have you looked at Pods?
 * [https://wordpress.org/plugins/pods/](https://wordpress.org/plugins/pods/)
 *  Thread Starter [superoctave](https://wordpress.org/support/users/superoctave/)
 * (@superoctave)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/looking-for-suggestions-for-creating-basic-database-help/#post-5680783)
 * No- I will definitely check it out!!
 * I’ve found a number of plugins that do this sort of thing, but most of them are
   pretty outdated and didn’t play nice with the latest version of WP. If this one
   works, it could be exactly what I’ve been looking for. Thanks!
 *  [WPyogi](https://wordpress.org/support/users/wpyogi/)
 * (@wpyogi)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/looking-for-suggestions-for-creating-basic-database-help/#post-5680784)
 * I’ve only played around with it, but it looks really pretty flexible and powerful.
   And I know the developer is quite responsive if you have questions about using
   it.
 *  Thread Starter [superoctave](https://wordpress.org/support/users/superoctave/)
 * (@superoctave)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/looking-for-suggestions-for-creating-basic-database-help/#post-5680791)
 * Wow! This seems to be exactly what I was looking for. Very powerful – and very
   straightforward. Thank you SO much!!

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

The topic ‘Looking for suggestions for creating basic database’ is closed to new
replies.

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [custom taxonomy](https://wordpress.org/support/topic-tag/custom-taxonomy/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [tables](https://wordpress.org/support/topic-tag/tables/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [superoctave](https://wordpress.org/support/users/superoctave/)
 * Last activity: [11 years, 3 months ago](https://wordpress.org/support/topic/looking-for-suggestions-for-creating-basic-database-help/#post-5680791)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics