增加
$register="insert into chat_user values('$name',$sex,PASSWORD('$passw'),'$question','$answer')";
$r_result=mysql_query($register) or die("query error");
修改$edit="update chat_user set name='$new_name', sex=$new_sex, passw=PASSWORD('$new_passw'), question='$new_question',answer='$new_answer' where name='$old_name'";
$e_result=mysql_query($edit) or die("THE ERROR INFORMATION");
$register="insert into chat_user values('$name',$sex,PASSWORD('$passw'),'$question','$answer')";
$r_result=mysql_query($register) or die("query error");
修改$edit="update chat_user set name='$new_name', sex=$new_sex, passw=PASSWORD('$new_passw'), question='$new_question',answer='$new_answer' where name='$old_name'";
$e_result=mysql_query($edit) or die("THE ERROR INFORMATION");
分别是:
update tablename set field1=value1,field2=value2....//修改
insert into tablename(field1,field2...)values(value1,value2...)//添加