Page 1 of 1

Need To Build A Gig List!

Posted: Tue Jul 07, 2009 7:45 am
by Rubin Remus
Hello everyone,

I'm hoping this is the right place to post this, I apologise if it isn't.

I'm trying to build a giglist for my band's website, because at the moment I have to keep editing the html and so forth. I'd like to learn to build one from scratch, because it might help in future and I'd like to understand it fully.

If there's anyone that can help me, I'd be forever grateful. I've checked the tutorial area, but had no joy.

Thanks in advance!

RR.

Re: Need To Build A Gig List!

Posted: Tue Jul 07, 2009 7:49 am
by onion2k
I take it a "gig list" is a very basic calendar ... a list of dates and where you'll be playing on that date? The first thing to do is to define your data structure - make a list of what you'll need to know for each gig. Once you have that you can design a little database for it.

Re: Need To Build A Gig List!

Posted: Tue Jul 07, 2009 7:55 am
by Rubin Remus
Thanks for the quick reply!

Yes, it is a calendar (never thought of it like that).

When you say the structure, do you mean insert the fields into PMA?

E.g,

Date
Location
Price
Other Notes

Sorry if I sound vague, but I'm new to this side of things.

Thanks.

Re: Need To Build A Gig List!

Posted: Tue Jul 07, 2009 7:58 am
by Rubin Remus
It might be worth saying that I'm going to need to build a back-end for it, as well, so other members of the band can list gigs.

Thanks.

Re: Need To Build A Gig List!

Posted: Tue Jul 07, 2009 9:00 am
by onion2k
Yes, I mean the columns for the database tables you'll create in PMA. That's the most important aspect of the website application - if you get the data structure right at the beginning the rest of the code will be easy because it'll just be a matter of writing pages to display the data (front end) and update the data (admin area). In a website or web application everything hinges on the data structure.

At the very minimum I would have thought a gig would need fields for:

Date
Location Name
Location Website URL
Location Address
Ticket Price
Ticket Sales Website URL (if people can buy tickets online)
Start Time
End Time
Support Act Name
Description
Owner ID (ID of the website user who created the gig record)
Created Date

Although, that said, I've only ever been to gigs as a member of the audience.