I have this script that you can select from a record, it will fill in the form fields to edit each record individually. I want it to return to the list after it is updated, and I would also like the option to delete the record if need be. Here is the script, any ideas.
<?php
mysql_connect();
mysql_select_db();
if($id){
if($submit){
$sql="UPDATE directory SET name='$name',address='$address',city='$city',state='$state',zip='$zip',phone='$phone',subsite='$subsite',subsitename='$subsitename',websitename='$websitename',category='$category',category1='$category1',category2='$category2',category3='$category3', keywords='$keywords' WHERE id=$id";
$result=mysql_query($sql);
echo"Thank you! Information updated.\n";
}else{
$sql="SELECT * FROM directory WHERE id=$id";
$result=mysql_query($sql);
$myrow=mysql_fetch_array($result);
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<input type=hidden name="id" value="<?php echo $myrow["id"]?>">
Name:<input type="text" name="name" value="<?php echo $myrow["name"]?>"><br>
Address:<input type="text" name="address" value="<?php echo $myrow["address"]?>"><br>
City:<input type="text" name="city" value="<?php echo $myrow["city"]?>"><br>
State:<input type="text" name="state" value="<?php echo $myrow["state"]?>"><br>
Zip:<input type="text" name="zip" value="<?php echo $myrow["zip"]?>"><br>
Phone:<input type="text" name="phone" value="<?php echo $myrow["phone"]?>"><br>
Subsite:<input type="text" name="subsite" value="<?php echo $myrow["subsite"]?>"><br>
Subsite Name:<input type="text" name="subsitename" value="<?php echo $myrow["subsitename"]?>"><br>
Website Address:<input type="text" name="websitename" value="<?php echo $myrow["websitename"]?>"><br>
Category:<input type="text" name="category" value="<?php echo $myrow["category"]?>"><br>
Category:<input type="text" name="category1" value="<?php echo $myrow["category1"]?>"><br>
Category:<input type="text" name="category2" value="<?php echo $myrow["category2"]?>"><br>
Category:<input type="text" name="category3" value="<?php echo $myrow["category3"]?>"><br>
Keywords:<input type="text" name="keywords" value="<?php echo $myrow["keywords"]?>"><br>
<input type="Submit" name="submit" value="Enter Information">
</form>
<?php
}
}else{
$query = "SELECT * FROM directory";
$result = mysql_query($query);
while ($myrow = mysql_fetch_array($result)){
printf("<a href=\"%s?id=%s\">%s</a><br>\n", $PHP_SELF, $myrow["id"], $myrow["name"]);
}
}
?>
Thanks in advance.
