<div style="font-family:tahoma; color:#F00; "> <?php session_start(); if (isset($_SESSION['user'])) echo "You are logged in as ".$_SESSION['user'], " to log out click <a href =logout.php>here</a>"; else die ("Please Register <a href =register.php>here</a>");?> </div> <?php $username = $_SESSION['user']; if(!isset($_SESSION['user'])) { header("location: login.php"); } else { $query=" SELECT * FROM users WHERE user='$username'"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $fn=mysql_result($result,$i,"FirstName"); $sn=mysql_result($result,$i,"SecondName"); $gen=mysql_result($result,$i,"Gender"); $email=mysql_result($result,$i,"Email"); $location=mysql_result($result,$i,"Location"); $username=mysql_result($result,$i,"user"); $password=mysql_result($result,$i,"password"); ++$i; } $u_fn=$_POST['FirstName']; $u_sn=$_POST['SecondName']; $u_gen=$_POST['Gender']; $u_email=$_POST['Email']; $u_location=$_POST['Location']; $u_username=$_POST['user']; $u_password=$_POST['password']; $query1="UPDATE users SET FirstName = '$u_fn', SecondName='$u_sn', Gender='$u_gen', Email='$u_email', Location=$u_location, user= $u_username, password='$u_password',"; mysql_query($query1); echo "Record Updated"; mysql_close(); } ?> <div id = "registercontent"> <h1> Edit your profile information here!</h1><br /> <form id='profile' style="text-align:left;" action='<?php echo $_SERVER['PHP_SELF']; ?>' method='post' accept-charset='UTF-8'> <fieldset > <legend><b>Enter details to create an account</b></legend> <input type='hidden' name='submitted' id='submitted' value='1'/><br /> <label for='FirstName' >First Name: </label> <input type='text' name='FirstName' id='FirstName' "maxlength="50" value = '<?php echo $fn ?>' /><br /><br /> <label for='SecondName' >Second Name:</label> <input type='text' name='SecondName' id='SecondName' maxlength="50" value = '<?php echo $sn ?>'/><br /><br /> <label for='gender' >Gender :</label> <input type="radio" name="gender1" <option value='<?php echo $gen ?>'>Male</option> <input type="radio" name="gender2" value="female">Female<br><br /> <label for='Email' >Email Address:</label> <input type='text' name='Email' id='Email' maxlength="50" value = '<?php echo $email ?>'/><br /><br /> <label for='Location' >Location :</label> <input type='text' name='Location' id='Location' maxlength="50"value = '<?php echo $location ?>' /><br /><br /> Please select your sports of interest from the list :<br /><br /> <select size="5" name="sport" multiple > <option selected> <option>Athletics <option>Badminton <option>Basketball <option>Beach Volleyball <option>Boxing <option>Canoe Slalom <option>Canoe Sprint <option>Cycling - BMX <option>Cycling - Mountain Bike <option>Cycling - Road <option>Cycling - Track <option>Diving <option>Equestrian <option>Fencing <option>Football <option>Gymnastics - Artistic <option>Gymnastics - Rhythmic <option>Handball <option>Hockey <option>Judo <option>Modern Pentathlon <option>Rowing <option>Sailing <option>Shooting <option>Swimming <option>Synchronised Swimming <option>Table Tennis <option>Taekwondo <option>Tennis <option>Trampoline <option>Triathlon <option>VolleyballWater Polo <option>Weightlifting <option>Wrestling </select> <i>(Hold CTRL while selecting sports)</i> <br /><br /> Please create a username and password you will use to sign in :<br /><br /> <label for='username' >Username: </label> <input type='text' name='username' id='username' maxlength="50"value = '<?php echo $username ?>' /><br /><br /> <label for='password' >Password: </label> <input type='password' name='password' id='password' maxlength="50"value = '<?php echo $password ?>' /><br /><br /> <label for='repeatpass' >Repeat Password: </label> <input type='password' name='repeatpass' id='repeatpass' maxlength="50" value = '<?php echo $password ?>'/><br /><br /> <input type="Submit" value="Update"> <input type="Submit" value="Cancel"> </fieldset> </form> </div> <div style="font-family:tahoma; color:#F00; "> i am having problems with my updating to the database, the information is shown in the form but when i click update it is not updating to the database, but is just refreshing the page... any help?
