I'm almost done making my registration system on my home server.

Thanks to everyone for your help.

The last thing I would like to know is why it says: Error: User not added to database.

This is part of my register code:

// Fields are clear, add user to database
    // Setup query
    $q = "INSERT INTO `dbusers` (`username`,`password`,`email`) "
    ."VALUES ('".$_POST["username"]."', "
    ."PASSWORD('".$_POST["password"]."'), "
    ."'".$_POST["email"]."')";

My database is made and named like in dbconfig.php

$db = "mysqladmin";

My table is dbusers but the columns/rows are made manually...

What could be the problem?

Hii,may be the username field is unique and you entered duplicate name in the same field... question: where the primary key of dbusers table you made?
%^^%Murtada%^^%

Oh I see, and I don't really understand the question but..
This is the query I'm trying to execute on SQL

CREATE TABLE dbUsers(
id int(10) Primary Key, AUTO_INCREMENT
username varchar(16) Unique
password char(16)
email varchar(25)

but it doesn't work....

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'username varchar(16) Unique
password char(16)
email varchar(25)' at line 3"

Okay, I'll try.

try this:

CREATE TABLE dbUsers(id int(10) Primary Key AUTO_INCREMENT,username varchar(16) Unique,password char(16),email varchar(25);

Everything seems to work when I don't input a password...
it's

password char(16)