Unknown error

[Rollo_Tamasi]

The error i'm getting is

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 '', '', '605353bb22e3311bc298aca399dac9a4', '1'' at line 2

The hash value is the password variable, 1 is the user

The mysql i'm using is

CREATE TABLE user (
  userid int(25) NOT NULL auto_increment,
  first_name varchar(25) NOT NULL default '',
  last_name varchar(25) NOT NULL default '',
  email_address varchar(25) NOT NULL default '',
  username varchar(25) NOT NULL default '',
  homepage varchar(25) NOT NULL default '',
  password varchar(25) NOT NULL default '',
  user_level enum('0','1','2','3','4') NOT NULL default '0',
  signup_date datetime NOT NULL default '0000-00-00 00:00:00',
  last_login datetime NOT NULL default '0000-00-00 00:00:00',
  activated enum('0','1') NOT NULL default '0',
  ip varchar(15) NOT NULL default '',
  company varchar(40) NOT NULL default '',
  gmail varchar(20) NOT NULL default '',
  msn varchar(20) NOT NULL default '',
  skype varchar(20) NOT NULL default '',
  aim varchar(20) NOT NULL default '',
  number varchar(20) NOT NULL default '',
  PRIMARY KEY  (userid)
) TYPE=MyISAM COMMENT='user table';CODE] 

The php file can be view as a phps file here:
http://www.cormacmoylan.com/blaa/register.phps

Any ideas what it could be?

[laserlight]

Does this look strange to you?

INSERT INTO user (first_name, last_name, email_address, ip, username, number, password, user_level )
        VALUES('$first_name', '$last_name', '$email_address', '$ip', $username', '$number', '$db_password', '1'

[Rollo_Tamasi]

afraid not tbh

[Installer]

Here's a hint. 🙂 There should be an even number of single quotes. I count fifteen.

[Rollo_Tamasi]

:quiet: woops! i blame my monitor and old age!