Welcome Guest, Not a member yet? Register   Sign In
DB design and file uploading
#1

[eluser]meigwilym[/eluser]
Hi,

I'm midway through building an app which needs a simple CMS to handle text and images.

First of all the text. The website promotes a series of music gigs for a festival. I want a system that can

- give a time and place
- add as many number of bands as needed

I want the markup to be

Code:
<li class="rss-item">
  <h4 class="pryd">Saturday 04/08, 9pm</h4>
  <h4 class="ble">Solus/Bar Solus</h4>
                                
  <ul class="artists">
    <li>Cate Le Bon</li>
    <li>Gwyneth Glyn</li>
    <li>The Gentle Good</li>
    <li>Georgia Ruth Williams</li>
  </ul>
</li>

The problem I have is how to put this info in a table. Do I need a Artists table like this?
[code]
gig_id | artist_name
[code]

or is there an easier/better way? It also needs to be bilingual.

I'll also need a way to upload images and display them - I'm fairly confident about this but any advice on librares, helpers etc is welcome.

The website is http://www.maesb.com/

Thanks for your help,

Mei


Messages In This Thread
DB design and file uploading - by El Forum - 07-16-2008, 12:27 PM
DB design and file uploading - by El Forum - 07-17-2008, 05:51 PM



Theme © iAndrew 2016 - Forum software by © MyBB