event list on website

[PaB]

I am not sure where I should post this, so I thought general would be best.

My son is a musician and I have built him a website. He wants me to add a show list similar to the one on his myspace page http://www.myspace.com/jordanlaynebourland

He wants it to only display the future shows and be easy to add to.

I have seen similar lists on other musicians websites, but I can't figure out what they use to do it with. What kind of scripting, coding or whatever is required? Is someone willing to give me some information? I am not asking for the code, how is it done? What do they use?

By the way, I have found the google calendar/feedburner option but he does not like the way that looks.

Thank you for any direction you can give me.

PaB

[ryanbutler]

It's done by server-side coding and a database. This is probably oversimplifying it, but you would have a SQL statement that would query for the current show date and display that, along with others forward. That way, any previous show dates wouldn't show. You would either have to administrate it through the database server itself or through an administrative interface.

There's probably something out there that would integrate that for you. What you basically need is an event calendar that would show upcoming musical shows. One I used that worked very well was Helios, but it was MySQL/PHP based. There's some .NET and Coldfusion out there as well.

[Scriptage]

I think you are looking for a complicated answer to a simple problem:

<table>
<tr>
<td>Venue</td><td>Price</td><td>Date</td>
</tr>
<tr>
<td>Manchester Evening News Arena</td><td>£35</td><td>08/03/2008</td>
</tr>

</table>

Just remove the row when the date has passed. As javascript is not allowed on MySpace this is the best you can do.

Regards

Carl

[PaB]

Ryan:

I think what you are saying is what I really want. We want it to be as low maintenance as possible but always up to date. Can you offer any good resources for me to use to start learning sql/php? I have done some very simple things with php in the past but I know that to do what he wants now I will have a lot to learn.

Thank you again,

PaB

[tracknut]

You could also look into installing easyphpcalendar.com, it's cheap and has all the interface you'd need to manage events, and a variety of display options including the flat list that you're looking for.

Dave

[Scriptage]

I must reiterate that you cannot do ANY of this on MySpace. If you purchase webspace and build a website from scratch then the things mentioned are options. There are workarounds using an external server and Flash but I must say everyone on here is barking up the wrong tree.

Regards

Carl

[tracknut]

I must reiterate that you cannot do ANY of this on MySpace. If you purchase webspace and build a website from scratch then the things mentioned are options. There are workarounds using an external server and Flash but I must say everyone on here is barking up the wrong tree.
I didn't see this as a request for a Myspace solution, but if it is, then my apologies.

Dave

[PaB]

Thanks to everyone for the replies. I really do appreciate the help but there seems to be some confusion about what I am trying to do. As I said in my original question:
"...I have built him a website. He wants me to add a show list similar to the one on his myspace page..."
I am not trying to add a list to his myspace page and I am not sure how my original question implied I was. Obviously they already have one available. He wants one like the one that is already on his myspace page added to his personal website.
Thank you again,
PaB

[Scriptage]

I'm sorry I misread your first post :rolleyes:

I'll have a look later and try to write a simple program for you.

Kind Regards

Carl