jarv
12-01-2008, 02:04 PM
Edit page
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Halo Hair Design</title>
<meta name="description" content="Hair Design salon and beuty"/>
<meta name="keywords" content="hair, design, salon, beauty, halo, sussex, worthing, south" />
<meta name="Content-Language" content="en-gb" />
<meta name="robots" content="FOLLOW,INDEX" />
<meta name="revisit-after" content="3 days" />
<meta name="copyright" content="www.mutecms.com" />
<meta name="author" content="www.mutecms.com - Professional web site design in the south uk, worthing, brighton" />
<meta name="distribution" content="Global" />
<meta name="resource-type" content="document" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="css/lightbox.css" title="default" />
<!--#include file="includes/functionlib.asp"-->
<%
logincheck()
opendb()
dim rs2
Set rs2 = objconn.Execute ("SELECT * FROM members WHERE UserID ="& Session("UserID"))
dim rs
Set rs = objconn.Execute ("SELECT * FROM settings")
Dim PageNo : PageNo = request("Pageno")
dim UserID : UserID = cint(session("UserID"))
set rs1 = objconn.execute("SELECT * FROM pages WHERE PageNo = " & PageNo )
%>
<script language="JavaScript" type="text/javascript" src="wysiwyg.js">
</script>
<!--#include file="sitecss.asp" -->
</head>
<body>
<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script>
<script type="text/javascript" src="js/lightbox.js"></script>
<div id="wrapper">
<div id="top">
<div id="logo">
<a href="default.asp" title="Halo Hair Design"><img src="images/logo.png" border="0" alt="Halo hair design logo"></a>
</div>
<div id="topright">
<div class="toprightnav"><a href="#" title="link1">Link</a> - <a href="#" title="link1">Link</a> - <a href="#" title="link1">Link</a> - <a href="#" title="link1">Link</a><br>
<form action="search_results1.asp" class="searchform" method="get" name="search">
<p>
<input name="s_halo" class="findbox" type="text" />
<input name="search" class="findbutton" value="Find" type="submit" />
</p>
</form></div>
<div class="contactnumber">Tel: 01903 237371</div>
</div>
<div id="headerpicture"></div>
<div id="navmid">
<div class="midnav">
<!--#include file="nav1.asp" -->
<a href="gallery.asp">Gallery</a>
<a href="shop-start.asp">Shop</a>
</div>
</div>
<div id="maintextholder">
<div id="textarea">
<h1><%=request.QueryString("msg")%></h1>
<h1>Edit <% = rs1("Title")%></h1>
<table border="0" cellspacing="0" cellpadding="0" class="copy">
<tr>
<td colspan="4"><%= request.QueryString("msg")%>
<input type="hidden" name="Pageno" value="<%=rs1("Pageno")%>"><%=Pageno%></td>
</tr>
<tr>
<td><form name="form1" method="post" action="update_page.asp?PageNo=<%=("Pageno")%>">
<table border="0" class="copy">
<tr><td>Title</td></tr>
<tr>
<td><input name="Title" type="text" class="Form_Fields_big" value="<%= rs1("Title")%>" > </td>
</tr>
<tr><td>Main Area </td></tr>
<tr>
<td><textarea id="textarea1" name="Body" rows="12" class="Form_Fields_big"><%= rs1("Body")%></textarea></td>
</tr>
<tr>
<td><input name="Submit" type="submit" class="form_buttons" value="Publish page"></td>
</tr>
</table>
<script language="javascript1.2">
generate_wysiwyg('textarea1');
</script>
</form>
</table>
</div>
<div id="textarearight">
<h2><%= rs("SideBarHeader")%></h2>
<%= rs("SideBarText")%>
<iframe width="300" height="150" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.co.uk/maps/ms?ie=UTF8&s=AARTsJpTV7z8g1EocUirzATyPya9gkFwjw&msa=0&msid=114730284187972093202.00045cead5440ef0c73 c1&ll=50.810491,-0.381432&spn=0.008135,0.025749&z=14&output=embed"></iframe>
</div>
</div>
<div id="bottomads"></div>
<div id="footer">Site design by <a href="http://www.mutecms.com/" title="muteCMS Professional Website Design" target="_blank"><img src="images/logo-mutecms.png" border="0" alt="mutecms logo"></a> © All Rights Reserved 2008</div>
</div>
<%
SET rs=NOTHING
SET rs1=NOTHING
SET rs2=NOTHING
Closedb()
%>
</div>
</body>
</html>
update page
<!--#include file="includes/functionlib.asp" -->
<%
logincheck()
opendb()
Dim PageNo : PageNo = request("Pageno")
Dim UserID : UserID = cint(session("UserID"))
Dim Body : Body = EncodeSQL(request.Form("Body"))
Dim Title : Title = EncodeSQL(request.Form("Title"))
Dim rs : set rs = objconn.execute("SELECT * FROM Pages WHERE PageNo = " & PageNo)
objconn.execute("UPDATE Pages SET Body = '" & Body & "',Title = '" & Title & _
"' WHERE Pageno = " & cint(rs("Pageno")))
msg = "Updated!"
set rs = nothing
closedb()
response.redirect "edit.asp?msg=" & msg & "&Pageno="&PageNo
%>
Can someone please help?! I edited Page 3 and it upadted Page 1?¬
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Halo Hair Design</title>
<meta name="description" content="Hair Design salon and beuty"/>
<meta name="keywords" content="hair, design, salon, beauty, halo, sussex, worthing, south" />
<meta name="Content-Language" content="en-gb" />
<meta name="robots" content="FOLLOW,INDEX" />
<meta name="revisit-after" content="3 days" />
<meta name="copyright" content="www.mutecms.com" />
<meta name="author" content="www.mutecms.com - Professional web site design in the south uk, worthing, brighton" />
<meta name="distribution" content="Global" />
<meta name="resource-type" content="document" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="css/lightbox.css" title="default" />
<!--#include file="includes/functionlib.asp"-->
<%
logincheck()
opendb()
dim rs2
Set rs2 = objconn.Execute ("SELECT * FROM members WHERE UserID ="& Session("UserID"))
dim rs
Set rs = objconn.Execute ("SELECT * FROM settings")
Dim PageNo : PageNo = request("Pageno")
dim UserID : UserID = cint(session("UserID"))
set rs1 = objconn.execute("SELECT * FROM pages WHERE PageNo = " & PageNo )
%>
<script language="JavaScript" type="text/javascript" src="wysiwyg.js">
</script>
<!--#include file="sitecss.asp" -->
</head>
<body>
<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script>
<script type="text/javascript" src="js/lightbox.js"></script>
<div id="wrapper">
<div id="top">
<div id="logo">
<a href="default.asp" title="Halo Hair Design"><img src="images/logo.png" border="0" alt="Halo hair design logo"></a>
</div>
<div id="topright">
<div class="toprightnav"><a href="#" title="link1">Link</a> - <a href="#" title="link1">Link</a> - <a href="#" title="link1">Link</a> - <a href="#" title="link1">Link</a><br>
<form action="search_results1.asp" class="searchform" method="get" name="search">
<p>
<input name="s_halo" class="findbox" type="text" />
<input name="search" class="findbutton" value="Find" type="submit" />
</p>
</form></div>
<div class="contactnumber">Tel: 01903 237371</div>
</div>
<div id="headerpicture"></div>
<div id="navmid">
<div class="midnav">
<!--#include file="nav1.asp" -->
<a href="gallery.asp">Gallery</a>
<a href="shop-start.asp">Shop</a>
</div>
</div>
<div id="maintextholder">
<div id="textarea">
<h1><%=request.QueryString("msg")%></h1>
<h1>Edit <% = rs1("Title")%></h1>
<table border="0" cellspacing="0" cellpadding="0" class="copy">
<tr>
<td colspan="4"><%= request.QueryString("msg")%>
<input type="hidden" name="Pageno" value="<%=rs1("Pageno")%>"><%=Pageno%></td>
</tr>
<tr>
<td><form name="form1" method="post" action="update_page.asp?PageNo=<%=("Pageno")%>">
<table border="0" class="copy">
<tr><td>Title</td></tr>
<tr>
<td><input name="Title" type="text" class="Form_Fields_big" value="<%= rs1("Title")%>" > </td>
</tr>
<tr><td>Main Area </td></tr>
<tr>
<td><textarea id="textarea1" name="Body" rows="12" class="Form_Fields_big"><%= rs1("Body")%></textarea></td>
</tr>
<tr>
<td><input name="Submit" type="submit" class="form_buttons" value="Publish page"></td>
</tr>
</table>
<script language="javascript1.2">
generate_wysiwyg('textarea1');
</script>
</form>
</table>
</div>
<div id="textarearight">
<h2><%= rs("SideBarHeader")%></h2>
<%= rs("SideBarText")%>
<iframe width="300" height="150" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.co.uk/maps/ms?ie=UTF8&s=AARTsJpTV7z8g1EocUirzATyPya9gkFwjw&msa=0&msid=114730284187972093202.00045cead5440ef0c73 c1&ll=50.810491,-0.381432&spn=0.008135,0.025749&z=14&output=embed"></iframe>
</div>
</div>
<div id="bottomads"></div>
<div id="footer">Site design by <a href="http://www.mutecms.com/" title="muteCMS Professional Website Design" target="_blank"><img src="images/logo-mutecms.png" border="0" alt="mutecms logo"></a> © All Rights Reserved 2008</div>
</div>
<%
SET rs=NOTHING
SET rs1=NOTHING
SET rs2=NOTHING
Closedb()
%>
</div>
</body>
</html>
update page
<!--#include file="includes/functionlib.asp" -->
<%
logincheck()
opendb()
Dim PageNo : PageNo = request("Pageno")
Dim UserID : UserID = cint(session("UserID"))
Dim Body : Body = EncodeSQL(request.Form("Body"))
Dim Title : Title = EncodeSQL(request.Form("Title"))
Dim rs : set rs = objconn.execute("SELECT * FROM Pages WHERE PageNo = " & PageNo)
objconn.execute("UPDATE Pages SET Body = '" & Body & "',Title = '" & Title & _
"' WHERE Pageno = " & cint(rs("Pageno")))
msg = "Updated!"
set rs = nothing
closedb()
response.redirect "edit.asp?msg=" & msg & "&Pageno="&PageNo
%>
Can someone please help?! I edited Page 3 and it upadted Page 1?¬