For some reason, I am able to delete the records selected via radio button but am unable to update the records selected via radio button. The pages function appropriately, but the database doesn't update the records. The code:
<fieldset><legend align="center"><b>Query Results</b></legend>
<form action="<?php echo $PHP_SELF; ?>" method="post">
<?php
@ $db = mysql_pconnect('host', 'username', 'pw');
mysql_select_db('dbname');
if (!$db)
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
}
if(!$Submit)
{
$result = mysql_query("select * from webform ORDER BY id ASC");
while($r = mysql_fetch_array($result))
{
$id=$r["id"];
$fullname=$r["fullname"];
$address=$r["address"];
$city=$r["city"];
$state=$r["state"];
$zip=$r["zip"];
$phone=$r["phone"];
$extension=$r["extension"];
$fax=$r["fax"];
$email=$r["email"];
$service=$r["service"];
$review=$r["review"];
$reviewduemonth=$r["reviewduemonth"];
$reviewdueday=$r["reviewdueday"];
$reviewdueyear=$r["reviewdueyear"];
?>
<input type="radio" name="id" value="<?php echo $id;?>">
<?php echo $fullname; ?><br />
<?php echo $address; ?><br />
<?php echo $city; ?>, <?php echo $state; ?> <?php echo $zip; ?><br />
Tel: <?php echo $phone; ?> Ext: <?php echo $extension; ?><br />
Fax: <?php echo $fax; ?><br />
Email: <?php echo $email; ?><br />
Service: <?php echo $service; ?><br />
Peer Review: <?php echo $review; ?><br />
Peer Review Date: <?php echo $reviewduemonth; ?> <?php echo $reviewdueday; ?>,
<?php echo $reviewdueyear; ?>
<br /><br />
<?php
}
?>
<input type="submit" name="Submit" value="Edit">
<input type="submit" name="Submit" value="Delete">
<?php
}
?>
<?php
if($Submit == 'Edit')
{
if (!$EditClient&&!$Cancel)
{
$sql = "SELECT * FROM webform WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
?>
<input type="hidden" name="id" value="<?php echo $myrow["id"]; ?>">
Client Name:<input type="text name="fullname" value="<?php echo $myrow["fullname"]; ?>" size=30><br />
Address:<input type="text" name="address" value="<? echo $myrow["address"]; ?>" size=30><br />
City:<input type="text" name="city" value="<?php echo $myrow["city"]; ?>" size=15>,
State:<select name="state">
<option>AL<option>AK<option>AZ<option>AR<option>CA<option>CO<option>CT<option>DE<option>DC<option>FL<option>GA<option>HI<option>ID<option>IL<option>IN<option>IA<option>KS<option>KY<option>LA<option>ME<option>MD<option>MA<option>MI<option>MN<option>MS<option>MO<option>MT<option>NE<option>NV<option>NH<option>NJ<option>NM<option>NY<option>NC<option>ND<option>OH<option>OK<option>OR
<option>PA<option>RI<option>SC<option>SD<option>TN<option>TX<option>UT
<option>VT<option>VA<option>WA<option>WV<option>WI<option>WY
</select>
Zip:<input type="text" name="zip" value="<?php echo $myrow["zip"]; ?>" size="5"><br />
Phone:<input type="text" name="phone" value="<?php echo $myrow["phone"]; ?>" size="15">
Ext:<input type="text" name="extension" value="<?php echo $myrow["extension"]; ?>" size="4"><br />
Fax:<input type="text" name="fax" value="<?php echo $myrow["fax"]; ?>" size="11"><br />
Email:<input type="text" name="email" value="<?php echo $myrow["email"]; ?>" size=40><br />
Service:
<input type="radio" name="service" value="Accounting/Auditing" />
Accounting/Auditing<br />
<input type="radio" name="service" value="Tax Services" />
Tax Services<br />
<input type="radio" name="service" value="Management Advisory" />
Management Advisory<br />
<input type="radio" name="service" value="Investment Planning" />
Investment Planning<br />
<input type="radio" name="service" value="Peer Review" />Peer Review
Peer Review type if applicable:<br />
<input type="radio" name="review" value="System Review" />
System Review<br />
<input type="radio" name="review" value="Engagement Review" />
Engagement Review<br />
<input type="radio" name="review" value="Report Review" />
Report Review<br />
Peer Review Due Date if applicable:<br />
<select name="reviewduemonth">
<option selected>
<option>January<option>February<option>March<option>April<option>May<option>June<option>July<option>August<option>September<option>October<option>November
<option>December
</select>
<select name="reviewdueday">
<option selected>
<option>1<option>2<option>3<option>4<option>5<option>6<option>7<option>8
<option>9<option>10<option>11<option>12<option>13<option>14<option>15<option>16
<option>17<option>18<option>19<option>20<option>21<option>22<option>23<option>24<option>25<option>26<option>27<option>28<option>29<option>30<option>31
</select>
<select name="reviewdueyear">
<option selected>
<option>2003<option>2004<option>2005<option>2006<option>2007<option>2008
</select>
<br />
<input type="hidden" name="Submit" value="Edit">
<input type="submit" name="EditClient" value="Edit client">
<input type="submit" name="Cancel" value="Cancel">
</form>
<?php
}
if($EditClient)
{
$sql = "UPDATE webform SET fullname=$fullname, address=$address, city=$city, state=$state, zip=$zip, phone=$phone, extension=$extension, fax=$fax, email=$email, service=$service, review=$review, reviewduemonth=$reviewduemonth, reviewdueday=$reviewdueday, reviewdueyear=$reviewdueyear WHERE id=$id";
$result = mysql_query($sql);
echo "Client Updated<br /><br /><a href='allclients.php'>Back to client results</a>";
}
if($Cancel)
{
echo "Update canceled<br /><br /><a href='allclients.php'>Back to client results</a>";
}
}
?>
<?php
if($Submit == 'Delete')
{
if (!$DeleteClient&&!$Cancel)
{
$sql = "SELECT * FROM webform WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
?>
<input type="hidden" name="id" value="<?php echo $myrow["id"]; ?>">
Client Name:<input type="text name="fullname" value="<?php echo $myrow["fullname"]; ?>" size=30><br />
Address:<input type="text" name="address" value="<? echo $myrow["address"]; ?>" size=30><br />
City:<input type="text" name="city" value="<?php echo $myrow["city"]; ?>" size=15>,
State:<input type="text" name="state" value="<?php echo $myrow["state"]; ?>" size=2>
Zip:<input type="text" name="zip" value="<?php echo $myrow["zip"]; ?>" size="5"><br />
Phone:<input type="text" name="phone" value="<?php echo $myrow["phone"]; ?>" size="15">
Ext:<input type="text" name="extension" value="<?php echo $myrow["extension"]; ?>" size="4"><br />
Fax:<input type="text" name="fax" value="<?php echo $myrow["fax"]; ?>" size="11"><br />
Email:<input type="text" name="email" value="<?php echo $myrow["email"]; ?>" size=40><br />
Service:
<input type="text" name="service" value="<?php echo $myrow["service"]; ?>" size=17>
Peer Review type if applicable:
<input type="text" name="review" value="<?php echo $myrow["review"]; ?>" size=17><br />
Peer Review Due Date if applicable:
<input type="text" name="reviewduemonth" value="<?php echo $myrow["reviewduemonth"]; ?>" size=9>
<input type="text" name="reviewdueday" value="<?php echo $myrow["reviewdueday"]; ?>" size=2>
<input type="text" name="reviewdueyear" value="<?php echo $myrow["reviewdueyear"]; ?>" size=4>
<br />
<input type="hidden" name="Submit" value="Delete">
<input type="submit" name="DeleteClient" value="Delete client">
<input type="submit" name="Cancel" value="Cancel">
</form>
<?php
}
if($DeleteClient)
{
$sql = "DELETE FROM webform WHERE id=$id";
$result = mysql_query($sql);
echo "Client Deleted<br /><br /><a href='allclients.php'>Back to client results</a>";
}
if($Cancel)
{
echo "Delete canceled<br /><br /><a href='allclients.php'>Back to client results</a>";
}
}
?>
</form></fieldset>
