<%@LANGUAGE="VBSCRIPT"%> <% Dim rsLogin__strPassword rsLogin__strPassword = "" if(Request.Form("Password") <> "") then rsLogin__strPassword = Request.Form("Password") %> <% set rsLogin = Server.CreateObject("ADODB.Recordset") rsLogin.ActiveConnection = "driver=MySQL;server=kingsmanor.com;database=miltondb;uid=milton;pwd=pitbauchlie;" rsLogin.Source = "SELECT * FROM PasswordList WHERE Password = '" + Replace(rsLogin__strPassword, "'", "''") + "'" rsLogin.CursorType = 0 rsLogin.CursorLocation = 2 rsLogin.LockType = 3 rsLogin.Open rsLogin_numRows = 0 %> <% If rsLogin__strPassword <> "" Then If Not rsLogin.EOF Then Session("svPassword") = (rsLogin.Fields.Item("Password").Value) Session("svName") = (rsLogin.Fields.Item("Name").Value) Session("svAccess") = (rsLogin.Fields.Item("Access").Value) Response.Redirect "welcome.asp" Else Response.Redirect "oops.asp" End If End If %> 3-star Hotels in Edinburgh, Scotland - the Kings Manor Hotel

The Fountain Spa Leisure Club

Membership promotion

Visit this page regularly to see our special offers

Have a look on the link below to see this months fantastic Membership Promotion.

Current Membership Promotion