I am doing a website in dw for a friends music venue and have nearly completed the site. What I need to do is create a page that would list the gigs that are on at the venue (that could be updated through contribute or some other CMS).
Our webserver has access to both ASP and perl modules. We also have unlimited MySQL databases.
I normally learn by doing but am struggling to find a way to do it or any tutorials for similar.
Bearing in mind the page formatting needs to look good regardless of how many gigs are listed. Ideally we would like to be able to search by artist and by date and be able to have the user sort the columns by date and artist also (ascending and descending). What they previously had is a 3 column table (artist, date, ticket price) (The artist details are also a link to artists websites) listing 10 gigs per page with next and previous links at the bottom to scroll through. Problem with this is that they currently pay someone to update the website every week with new gig dates. They want to be able to do it theirselves whenever new gigs are confirmed.
Can anyone give me some help as to the steps I need to take to get this working ( a step by step guide would be really appreciated or possibly some good links that describe the process in detail). Thanks in advance