please point me in the right direction.

robhargreaves

I have set up a phpBB and have access to mysql 4.x on my server (Tripod). I would like to create a forum in a category then instead of it taking the user of the site to a page of topics I would like it to take them to a custom HTML page.

I have a layout in mind but but would like to hold information in the mysql database for display on the table.

The table structure I have in mind is:

Reg (validated text)
First Name (text)
Town/City (text)
County (list)
Country (list)
Colour (list)
Chassis Code (list - DW/EW)
Built (Date)
Registered (Date)
Mileage (number)
Condition (list - concours/standard/modified/destroyed)
Comments (text)

Where and how would I add a table like this into the database?

Thanks in advance

Rob - If this is going to be too complicated for you to explain in detail then no problem just simplify your answer into bullets or similar and then I can research / try a step by step as i learn approach :->

tha_mink

CREATE TABLE custom_table (
id NOT NULL auto_increment PRIMARY KEY,
Reg varchar(255) ,
First Name varchar(30) ,
Town/City varchar(255),
County varchar(255) ,
Country varchar(255),
Colour varchar(255),
Chassis Code varchar(255),
Built int(14),
Registered int(14),
Mileage int(14),
Condition varchar(60), 
Comments text
);

You can adjust the field names and types...like varchar(255) can be varchar(50) if you only need 50 characters of space...etc.