I just noticed something while reading through this post.
Here is the create table code
create table uuser (
user_id int not null auto_increment primary key,
user_name text,
real_name text,
email text,
password text,
remote_addr text,
confirm_hash text,
is_confirmed int not null default 0
);
Here is the insert code
INSERT INTO uuser
(
user_id,
user_name,
real_name,
password,
email,
remote_addr,
confirm_hash,
is_confirmed
)
VALUES
(
'NULL',
'$user_name',
'$password',
'$email',
'$remote_addr',
'$confirm_hash',
'$is_confirmed'
)
You are trying to insert NULL into a field that has been defined as NOT NULL. Also you have 8 fields in the table, 8 fields in the insert part of the insert statement, yet only 7 fields in the values section of the insert statement.
You need something like this
VALUES
(
'',
'$user_id',
'$user_name',
'$real_name',
'$email',
'$password',
'$remote_addr',
'$confirm_hash',
'$is_confirmed'
);
wabirdman