Parsing information to db - settings

[CaptainB]

Hi guys!

I have a php script, which I've modified and populated with extra fields, which will, via a form, submit data like name, email etc into a mysql db. But I have a problem.

Most of the fields, except the username, password and email field, will not submit the information to the db.

Here's the command I used to create the fields in the db. Can you spot any errors or tell me why it does not work? (even though this is very sparse information. Commands in bold do work.):



CREATE TABLE users (
username varchar(30) primary key,
password varchar(32),
userid varchar(32),
userlevel tinyint(1) unsigned not null,
email varchar(50),
name varchar(150),
gender varchar(50),
country varchar(50),
website varchar(50),
interests varchar(1000),
occupation varchar(150),
system_specs varchar(1000),
tools_of_the_trade varchar(1000),
fav_band_or_musican varchar(1000),
fav_style_or_digital_art varchar(1000),
operating_system varchar(150),
personal_quote varchar(1000),
timestamp int(11) unsigned not null
);

[Fumigator]

The error message that you receive when you run the query will tell you what's wrong :thumbsup:

[CaptainB]

Well, that's the problem - it returns no error message but as succes one instead. I just wondered if I had applied incorect settings to the fields, as they does not get the information. I guess the error lies in the php then.

[abduraooft]

system_specs varchar(1000),
tools_of_the_trade varchar(1000),
fav_band_or_musican varchar(1000),
fav_style_or_digital_art varchar(1000),

personal_quote varchar(1000),

off topic: How about text type ?