{
if (empty($Cusername))
{
$ErrMsg = $ErrMsg."Please enter your username. <BR>";
}
else
{
$sql3 = "select * from member where username = '$Cusername'";
$result = mysql_query($sql3) or die ("Cannot insert into member");
if (mysql_num_rows($result)>0)
{
$ErrMsg = $ErrMsg."Member with this username exits already.<BR>";
}
}
if (empty($Cpass))
$ErrMsg = $ErrMsg."Please enter your password. <BR>";
if (empty($Cname))
$ErrMsg = $ErrMsg."Please enter your name. <BR>";
if (empty($Ccreditcardno))
$ErrMsg = $ErrMsg."Please enter your credit card number. <BR>";
}
else
{
$sql4 = "update member set NewUser='Cusername', NewPass='Cpass', NewName='Cname', NewSurname='Csurname', NewGender='Cgender', NewEmail='Cemail', NewAddress='Caddress', NewPhoneNo='Cphoneno', NewShipping='Cshipping_ad', NewCreditcard='Ccreditcardno'";
mysql_query($sql4);
if (mysql_errno !=0)
{
print mysql_error();
print "<BR>";
}
else
{
#include ("MyAccount.php");
#header("location:MyAccount.php");
}
}
<input type="submit" name="edit" value="edit">
=======================================================
SQL
create table member
(user_id int primary key not null auto_increment,
username varchar(15) not null,
password varchar(15) not null,
name varchar(30) not null,
surname varchar(50) not null,
gender char(1) not null,
dob varchar(15) not null,
email varchar(30) not null,
address varchar(200) not null,
phoneno varchar(20) not null,
shipping_ad varchar(200) not null,
creditcardno varchar(16) not null,
collected_point int not null,
last_login timestamp not null);
1.The update doesn't work.
2.When I remove comment from else
else
{
#include ("MyAccount.php");
#header("location:MyAccount.php");
}
I can't access the current page.
