error=update member set name = 'wert', lastname ='wert', gender ='M', day ='3', month ='2', year ='2015', address =' wert' email ='' where username = ''

<?
	@session_start();
	include("connect.php");
	$name		 =$_POST['name'];
	$lastname	 =$_POST['lastname'];
	$gender		 =$_POST['gender'];
	$day		 =$_POST['day'];
	$month		 =$_POST['month'];
	$year		 =$_POST['year'];
	$address	 =$_POST['address'];
	$email		 =$_POST['email'];

		$birthday	= "$year-$month-$day"; 
		$sql= "update member set
			name = '$name',
			lastname	 ='$lastname',
			gender		 ='$gender',
			day			 ='$day',
			month		 ='$month',
			year		 ='$year',
			address		 ='$address'
			email		 ='$email'
			where username = '{$_SESSION['username']}'";	
		mysql_query($sql) or die("error=$sql");
		echo "<script>alert(' ++ Complete ++ ');window.location='main.php';</script>";
?>

<?
	@session_start();
	if ($_SESSION['username'])
	{
		echo "<script>alert(' !! Please Login !! ');window.location='index.php';</script>";
		exit();
	}

	include("connect.php");
	$username =$_SESSION['username'];
	$sql    = "select * from member where username = '$username' " ;
	$query  = mysql_query($sql) or die("error=$sql");
	$row	= mysql_fetch_array($query);

?>
<link href="../style.css" rel="stylesheet" type="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<form  name="form1" method="post" action="editsave.php">
<table width="1154" height="547" border="1" align="center">
  <tr>
    <td align="center"><p>++EditProfile++</p>
    <p>::Profile::</p>
    <p>name    
      <label for="textfield"></label>
      <input type="text" name="name" id="name" value="<?=$row['name']?>"/>
    </p>
    <p>lastname 
      <label for="textfield2"></label>
      <input type="text" name="lastname" id="lastname" value="<?=$row['lastname']?>"/>
    </p>
    <p>gender
      <label for="textfield3"></label>
      <input type="radio" name="gender" id="radio" value="M" 
      <? if ($row['gender'] == "M")echo 'checked="checked"';  ?>> male
	  <input type="radio" name="gender" id="radio" value="F" 
	  <? if ($row['gender'] == "F")echo 'checked="checked"';  ?> > female </p>
    <p>birthday
    <?
		list($y,$m,$d) = split("-",$row['birthday']);
	?>
      <select name="day" id="day">
        <? for ($i =1; $i<=31;$i++) { ?>
        <option value="<?=$i?>" <? if($i==$d)echo 'selected="selected"'; ?>><?=$i?>
          </option>
        <? }	?>
      </select>
      <label for="select2"></label>
      <select name="month" id="month">
        <? 
		$mname =  array (' ','Jan','Feb','Mar ','Apr ',' May','Jun','Jul ',' Aug',' Sep',' Oct',' Nov',' Dec');
		for ($i=1 ; $i<=12;$i++)
		{
			?>
        <option value="<?=$i?>" >
          <?=$mname[$i]?>
          </option>
        <? }	?>
      </select>
      <label for="select3"></label>
      <select name="year" id="year">
        <? for ($i =date ("Y");$i>=date("Y")-80;$i--) { ?>
        <option value="<?=$i?>" >
          <?=$i?>
          </option>
        <? }	?>
      </select>
    </p>
    <p>address
      <label for="textfield3"></label>
      
      <textarea  name="address" id="address" > <? $row['address'] ?></textarea>
    </p>
    <p>email
      <label for="textfield4"></label>
      <input type="text" name="textfield4" id="textfield4" />
    </p>
    
      <input type="submit" name="button" id="button" value="Submit" />

    <p>&nbsp;</p></td>
  </tr>
  
</table>
  </form>