calling all php and mysql guru's

[CP,]

Originally Posted by SirAdrian

What is the $member_id value set to? I'm assuming it's an integer... right?

look here: http://www.photo-host.org/img/958319table.jpg member id is an auto increment integer.

CREATE TABLE contacts (
  member_id int(30) NOT NULL auto_increment,
  firstname varchar(30) NOT NULL default '',
  surname VARCHAR(30) NOT NULL default '',
  contact_no INT(11),
  housename_no VARCHAR(20),
  address_line1 VARCHAR(20),
  address_line2 VARCHAR(20),
  address_line3 VARCHAR(20),
  city_county VARCHAR(15),
  postcode VARCHAR(8),
  email varchar(30) NOT NULL default '',
  username varchar(25) NOT NULL default '',
  password varchar(255) NOT NULL default '',
  PRIMARY KEY  (member_id),
  UNIQUE KEY username (username)
) TYPE=MyISAM COMMENT='Members';