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.
PHP Concert/Events Page
Moderator: General Moderators
-
kettle_drum
- DevNet Resident
- Posts: 1150
- Joined: Sun Jul 20, 2003 9:25 pm
- Location: West Yorkshire, England
-Create the database table:
-Then create a form to add details and submit it to a page that has something like:
-Then have a page that grabs the data from the database
Code: Select all
CREATE TABLE events (
date int(10) NOT NULL,
event varchar(255),
..........
);Code: Select all
mysql_query("INSERT INTO events (date, event, time) VALUES ('{$_POST['date']}', '{$_POST['event']}')");