Problems with date and time strings and putting them into sql

[Johny Favourite]

Ok, first my sql/php knowledge is not the best.

What I want to do is have a database that stores times of radio shows.

So basically I would have

Showname
Showdate
Showstart
Showfinish

In the table.

I'm not sure what type of fields I should set them to.

Also I would like to make a page to add shows to the Db. I'm not sure how I would do that either.

Sorry if this is a really big ask!

[thedagda]

This request is fairly simple, but a lot more information is needed from you. I suggest looking at a couple of these tutorials. You should be able to pick it up in no time.

PHP/MySQL tutorial:
[freewebmasterhelp.com...]

MySQL manual on date/datetime columns:
[dev.mysql.com...]

Any questions, just let me know, I'd be happy to explain further.

Conor