数据表结构create table UserInfo
(
ID int not null auto_increment,
UserID varchar(10) not null,
Passwd varchar(10) not null,
Name varchar(10) not null,
Email varchar(100) not null,
Phone1 varchar(20) not null,
Phone2 varchar(20),
Address varchar(150) not null,
Descript varchar(255),
primary key (ID)
);
(
ID int not null auto_increment,
UserID varchar(10) not null,
Passwd varchar(10) not null,
Name varchar(10) not null,
Email varchar(100) not null,
Phone1 varchar(20) not null,
Phone2 varchar(20),
Address varchar(150) not null,
Descript varchar(255),
primary key (ID)
);
(ID,Username,Passwd,Name,Email,Phone1,Phone2,Address,Descript) values
...
@mysql_select_db("homemaking",$connid)or die(选择失败);
...
$Phone2-trim($Phone2);==>$Phone2=trim($Phone2);
$query="insert into userinfo (ID,Username,Passwd,Name,Email,Phone1,Phone2,Address,Descript) values ('','$Username','$Passwd','$Name','$Email','$Phone1','$Phone2','$Address','$Descript')";
mysql_select_db("homemaking",$connid)or die(选择失败);
...
INSERT INTO UserInfo (ID, UserID, Passwd, Name, Email, Phone1, Phone2, Address, Descript) VALUES (NULL, '{$UserID}', '{$Passwd}', '{$Name}', '{$Email}', '{$Phone1}', $Phone2, '{$Address}', $Descript)
$Passwd=trim($Passwd);
$Name=trim($Name);
$Email=trim($Email);
$Phone1=trim($Phone1);
$Phone2-trim($Phone2);
$Address=trim($Address);
$Descript=trim($Descript);看SQL语句是对的了,看看是不是你赋值的这些变量,没有取得后面如trim($Username)的值,你试一下,用echo $Username能不能输出