I have a Form that Loads my data then can change Information and hit the Update Button nothing happens I can not find the Problem :mad: Please help
Code from Form
<?php
include ('conn.php');
error_reporting(0);
$id = $_GET['id'];
$result = mysql_query("SELECT * FROM pl_users WHERE id=$id",$con);
$myrow = mysql_fetch_array($result);
?>
<form action="_update.php" method="post" id="_editform" >
<table width="75%" border="1" align="center">
<tr>
<td width="27%">EDIT RECORD </td>
</tr>
<tr>
<td width="27%">FIRSTNAME</td>
<td width="73%"><input type="text" value="<?php echo $myrow['firstname'] ?>" name="firstname" /></td>
</tr>
<tr>
<td>LASTNAME</td>
<td><input type="text" value="<?php echo $myrow['lastname'] ?>" name="lastname" /></td>
</tr>
<tr>
<td>STREET</td>
<td><input type="text" value="<?php echo $myrow['street'] ?>" name="street" /></td>
</tr>
<tr>
<td>CITY </td>
<td><input type="text" value="<?php echo $myrow['city'] ?>" name ="city" /></td>
</tr>
<tr>
<td>STATE</td>
<td><input type="text" value="<?php echo $myrow['state'] ?>" name="state" /></td>
</tr>
<tr>
<td>ZIP CODE </td>
<td><input type="text"value="<?php echo $myrow['zip'] ?>" name ="zip" /> </td>
</tr>
<tr>
<td>HOME PHONE </td>
<td><input type="text" value="<?php echo $myrow['hphone'] ?>" name ="hphone" /></td>
</tr>
<tr>
<td>CELL PHONE </td>
<td><input type="text" value="<?php echo $myrow['cphone'] ?>" name ="cphone" /></td>
</tr>
<tr>
<td>E-MAIL</td>
<td><input type="text" value="<?php echo $myrow['email'] ?>" name ="email" /></td>
</tr>
<tr>
<td>PLEDGE DATE </td>
<td><input type="text" value="<?php echo $myrow['pldate'] ?>" name ="pdate" /></td>
</tr>
<tr>
<td>PLEDGE AMOUNT </td>
<td><input type="text" value="<?php echo $myrow['plamount'] ?>" name ="pamount" /></td>
</tr>
<tr>
<td> </td>
<td><input type="hidden" name="id" value="<?php echo $id ?>" />
<input type="submit" name="Submit" value="SAVE " />
CLICK<a href="members1.php"> HERE </a>TO GO BACK</td>
</tr>
</table>
</form>
</div>
<html>
<title>Update Record</title>
</head>
<body>
</body>
</html>
<div id="contentright">
</p>
<p>
</p>
</div>
</div>
CODE FROM Update
<?PHP
include ('conn.php');
error_reporting(0);
$id = $_POST['id'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$street = $_POST['street'];
$city = $_POST['city'];
$state = $_POST['state'];
$zip = $_POST['zip'];
$hphone = $_POST['hphone'];
$cphone = $_POST['cphone'];
$email = $_POST['email'];
$pdate = $_POST['pldate'];
$pamount = $_POST['plamount'];
$_rs ="UPDATE pl_users
SET pl_users.firstname ='$firstname',
pl_users.lastname ='$lastname',
pl_users.street ='$street',
pl_users.city ='$city',
pl_users.state ='$state',
pl_users.zip ='$zip',
pl_users.hphone ='$hphone',
pl_users.cphone ='$cphone',
pl_users.pldate ='$pdate',
pl_users.plamount ='$pamount',
pl_users.email ='$email',
WHERE pl_users.id = '$id';";
$query=mysql_query($_rs);
echo "<p>record has been updated click </p> <a href=\"members1.php\"> here </a> to continue";
//header("Location:index.php");
?>
