Quote:
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.
Code:
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';