Page 1 of 1

PHP Concert/Events Page

Posted: Sat Nov 13, 2004 6:17 pm
by Obed
Hi, I am trying to do a database driven concert page for my music website.

With the folowing fields:

- Date
- Event
- Time
- Venue
- Info

I want to be able to access this form online and update my concert page.

How can I do this?

Some examples are below:

http://www.delirious.co.uk/tournews.html
http://www.delirious.co.uk/tournews.html

Weirdan | Don't spam the board. One thread is enough for one question. Other threads removed.

Posted: Sun Nov 14, 2004 4:17 am
by kettle_drum
-Create the database table:

Code: Select all

CREATE TABLE events (
   date int(10) NOT NULL,
   event varchar(255),
   ..........
);
-Then create a form to add details and submit it to a page that has something like:

Code: Select all

mysql_query("INSERT INTO events (date, event, time) VALUES ('{$_POST['date']}', '{$_POST['event']}')");
-Then have a page that grabs the data from the database