<% if request.form("sent") = "yes" then Dim CheckSQL, RSCheck CheckSQL = "SELECT * FROM Forces_Registrants WHERE (Username = '"&killChars(request.form("username"))&"' or Password ='"&killChars(request.form("pword"))&"' )" Set RSCheck = MyConn.Execute(CheckSQL) If RSCheck.EOF Then SQLINSERT = "INSERT INTO Forces_Registrants (FirstName, LastName, Location, TelNo, Email, Username, Password, DOB, Deleted, EntryDate, Type, BFPOCampaign) " SQLINSERT = SQLINSERT & " VALUES ('"&killchars(request.form("firstname"))&"', '"&killchars(request.form("lastname"))&"','"&killchars(request.form("plocation"))&"', " SQLINSERT = SQLINSERT & " '"&killchars(request.form("telno"))&"', '"&killchars(request.form("email"))&"', '"&killchars(request.form("username"))&"', '"&killchars(request.form("pword"))&"', " SQLINSERT = SQLINSERT & " Convert(datetime,'"&request.form("dob")&"',103), 'no', Convert(datetime,'"&now()&"',103), 'user', '"&killchars(request.form("BFPOCampaign"))&"' ) " MyConn.execute(SQLINSERT) SQLGetID = "SELECT TOP 1 AccountID FROM Forces_Registrants ORDER BY AccountID DESC " SET RSID = MyConn.execute(SQLGetID) session("AccountID") = RSID("AccountID") response.redirect "myaccount.asp" ELSE response.redirect "register.asp?applied=failed" end if end if %>

REGISTER

<%'GetCurMemb = "SELECT count(*) as num FROM Forces_Registrants WHERE Deleted = 'no' and Type = 'user' " 'SET RSCurMemb = MyConn.execute(GetCurMemb)%> <%'GetCurMemb7 = "SELECT count(*) as num FROM Forces_Registrants WHERE Deleted = 'no' and Type = 'user' AND EntryDate >= CONVERT(datetime, '"&DateAdd("d", -7, now())&"', 103) " 'SET RSCurMemb7 = MyConn.execute(GetCurMemb7)%>

This new site has been designed to provide forces personnel and those connected to the forces with an opportunity to Buy, Sell and place Wanted ads to like minded individuals. Everything is free for the first 3 months, so why on earth wouldn't you give it a try. The majority of our pages are free to use permanently.

REGISTRATION FORM

Please complete the below form to register with forces notice boards, all fields are required.

<%if request("applied")= "failed" then%>
Registration Failed : Username or password already exist! Please try again.
<%end if%>
First Name*
Surname*
Location Postcode or BFPO Number*
Telephone Number
E-mail Address*
Confirm E-mail Address*
Date of Birth (DOB)* eg. dd/mm/yyyy
User Name*
Select Password*
must be over 7 digits with at least 1 numeric

I am happy to subscribe to the BFPO campaign. Untick the box if you wish to opt out.
 
* donates required fields.

WHY WE ARE DIFFERENT?

1.  This site makes only one charge to the seller which is far lower than that of other sites.

2.  Length of time adverts are displayed for can be much longer.

3.  Two pictures free within the cost of the ad?

4.  This site is primarily aimed at serving and ex forces, this will provide a specific search base for items used primarily by forces personnel