<% Dim mloc,sql Set mloc= Server.CreateObject("ADODB.Recordset") sql = "Select Cities.Name , States.State From (States Inner Join Countries on States.country=Countries.Id) Inner Join Cities on Cities.State=States.Id " mloc.Open sql,ObjConn,adOpenDynamic,adLockOptimistic %>

Sign Up Area
 ACCOUNT DETAILS (* = required)  
 Email Address   *
   
 Choose Password *
 Confirm Password *
 Choose Nickname * (This will be your username)
 First Name *
 Last Name *
Gender
Current relationship
 Complete Postal Address *
 City *
 State
 ZIP Code *
 Country
 Date Of Birth: MM DD   YYYY

 Choose Hint Question *
 This will be used to confirm your Identity when you

 request for a lost password lookup
 Hint Answer *
Photo Image File Name  
Click Upload to search for photo on your PC
 Day Time Phone - -
 Fax Number --
 Your Profile *
 Enter Description about yourself up to 50 words