[Dean C]

that code is already there... and its exactly the same as the code u gave me above...

and also i did upload the original and that didn't fix it... i have a feeling it has something to do with these querys i ran:

if u can give me thr query to reverse each one id give that a try:

Query1:
[sql]
CREATE TABLE award (
awardsid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
name varchar(60) NOT NULL,
url varchar(100) NOT NULL,
aw smallint(4) NOT NULL,
PRIMARY KEY (awardsid)
);
[/sql]

Query2:
[sql]
CREATE TABLE useraward (
id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
awardsid smallint(5) NOT NULL,
userid smallint(5) NOT NULL,
name varchar(60) NOT NULL,
url varchar(100) NOT NULL,
aw smallint(4) NOT NULL,
PRIMARY KEY (id)
);
[/sql]

Quer3:
[sql]
ALTER TABLE user ADD award TINYTEXT NOT NULL
[/sql]

Thanks in Advance

- Mist