Database....

[LA_MERC_th33_r00k]

I have a project that I am wanting to do. It will involve a webpage that people will register for and I want to log some of the info into a database.

1. Username
2. Email addy
3. Physical Address
4. Zip Code
5. Answers to a "comment card" style checklist.
- 10 areas x 1-5 rating that produces an "avg" overall rating.
6. Open writing area limited to 100 characters or so.

The gist of the website will be renters rating their landlords and their landlord's property they rent.

Rook

[LA_MERC_WBHighwind]

I think ms access can output a script that you can load onto a server so you can have people fill out a form and it inputs it into a data base. Im not sure though cuz its been 3 years since I took that INFO class that covered what access does.

[LA_MERC_goose]

SQL is your friend. MySQL will work.

create table <insert table name here>
record_id number not null,
username varchar(25) not null,
email_address varchar(100),
address_line_1 varchar(100),
address_line_2 varchar(100),
city varchar(50),
state char(2),
zip_code varchar(10),
question_1 number .... question_10 number

I've done the same kind of thing with the membership page on here with MySQL. I use Oracle on a daily basis with my real job and I used Informix for 4 years at my previous job. Let me know if I can be of assistance. I love this stuff!

[LA_MERC_th33_r00k]

Hey you can be of assistance.