rendered paste body//already connected & selected database//If cmd has not been initializedif(!isset($cmd)) { $result = mysql_query("select * from webpages order by id"); while($r=mysql_fetch_array($result)) { $pagedesciption=$r["pagedesciption"]; $keywords=$r["keywords"]; $pagebody=$r["pagebody"]; $pagename=$r["pagename"]; $id=$r["id"]; echo "$pagename - <a href='edit.php?cmd=edit&id=$id'>Edit</a>"; echo "<br>"; }}if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit"){ if (!isset($_POST["submit"])) { $id = $_GET["id"]; $sql = "SELECT * FROM webpages WHERE id=$id"; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); echo "<form action=save.php method=post>"; echo "<input type=hidden name=id value=$myrow[$id]>"; echo "Page Name:"; echo "<INPUT TYPE=TEXT NAME=title VALUE=$myrow[pagename] SIZE=30><br>"; echo "Keywords:"; echo "<INPUT TYPE=TEXT NAME=keywords VALUE=$myrow[keywords] SIZE=30><br>"; echo "Description:"; echo "<INPUT TYPE=TEXT NAME=pagedesciption VALUE=$myrow[pagedesciption] SIZE=30><br>"; echo "Page Body:"; echo "<TEXTAREA NAME=pagebody ROWS=10 COLS=30>$myrow[pagebody]</TEXTAREA><br>"; echo "<input type=hidden name=cmd value=edit>"; echo "<input type=submit name=submit value=submit>"; echo "</form>"; }}////////////save.php//////////// if ($_POST["$submit"]) { $pagename = $_POST["pagename"]; $pagedesciption= $_POST["pagedesciption"]; $pagebody = $_POST["pagebody"]; $keywords = $_POST["keywords"]; $sql = "UPDATE webpages SET pagename='$pagename',pagedesciption='$pagedesciption',pagebody='$pagebody',keywords='$keywords', WHERE id=$id"; $result = mysql_query($sql); } include("edit.php");