Code: Select all
mysql_query("CREATE TABLE education (
pid bigint(50) NOT NULL auto_increment,
userid bigint(50) NOT NULL default '0',
qualification int(11) NOT NULL default '0',
) ";
mysql_query("
CREATE TABLE user (
userid bigint(100) NOT NULL auto_increment,
email varchar(255) NOT NULL default '',
city varchar(255) default NULL,
contacted varchar(50) NOT NULL default '',
notes varchar(255) NOT NULL default '',
one varchar(50) NOT NULL default '',
two varchar(50) NOT NULL default '',
three varchar(50) NOT NULL default '',
PRIMARY KEY (userid)
)");thanx in advance.
Mannan.