//already connected & selected database //If cmd has not been initialized if(!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 - Edit"; echo "
"; } } 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 "
"; echo ""; echo "Page Name:"; echo "
"; echo "Keywords:"; echo "
"; echo "Description:"; echo "
"; echo "Page Body:"; echo "
"; echo ""; echo ""; echo "
"; } } //////////// 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");