Am I thinking right? (php, MySQL)

I have very limited knowledge in php and MySQL, but I want to implement some stuff on a website I'm making. Could anyone with knowledge in php and MySQL just check if I'm going about this in the correct way, or if I'm making it way too complicated?

What I want to do is to make an event list for a band. I want them to have a private html on their site that contains a simple form. In this form you input name of the venue, link to the venue, location (town), location (country), date of the gig and time of the gig.

Here comes the php/MySQL part. I want the format displayed on the main site to be:

<Date>, <Time>
<NAME OF VENUE>, <Town>, <Country>
<Link to website of venue> (presented in "click here" format)

So the way I was thinking of doing it would be:

Create 6 different tables in a database called xxxx_events, one for every entry.

Then just call them from the main site, something like this:

Code:

echo('<div class="events">
<p><b>'.$date.', '.$time.'</b></p>
<p><b>'.$venue.', '.$town.', '.$country.'</b></p>
<p><a href="'.$link.'">Click here for directions and information</a></p>
</div>');

Would this work?

 

Ok, so one table containing all the information will do fine, got it.

I'm starting to get lost here.

By "projecting data", do you mean the way I want to present it on the website?

Yeah, I didn't include all the code needed in my example of course. I understand that there has to be sql calls and such, and that I can format the way the date is presented (for example 20 Oct 2009).

Right now I've made a very simple shoutbox on the website (http://s77028.gridserver.com/), which I made from this tutorial: http://net.tutsplus.com/tutorials/php/create-a-basic-shoutbox-with-php-and-sql/

To display the comments in the shoutbox I've done this:

Code:

echo('<li><div class="shout"><p><b>- '.$epost.'</b> /'.$ename.'</p></div></li>');

My plan was to base my event list creation on the same principals I've picked up through that tutorial. But you're saying there's an easier way perhaps?

If you know of any very easy-to-follow tutorials for creating an event list, let me know!

 

Oh, and just so I'm clear on the basic principal:

To make an event list, I would just

1. Input data into a database (through a form in my case)
2. Pull the data from the database
3. Format the data using php
4. Present it on the website using CSS

Have I understood the basics of it?