title: Profile Post Code Search Finder Nearest Carrer
body: <p>I have a web site that is Facebook for the old to find careers around the UK however the owner has asked for postcode partial search to be in place and that and a distance selection so they can search for careers in say 5 10 15 miles distances from the original postcode. I store postcode and long and latitude into the profile table.</p>
  
  <p>userid int(11) Yes     NULL<br>
  profile_pic text    Yes     NULL<br>
  qualification   text    Yes     NULL<br>
  education   int(11) Yes     NULL<br>
  patient int(11) Yes     NULL<br>
  carer   int(11) Yes     NULL<br>
  telephone   varchar(50) Yes     NULL<br>
  mobile  varchar(50) Yes     NULL<br>
  gender  int(11) Yes     NULL<br>
  profile_areas   int(11) Yes     NULL<br>
  type    int(11) Yes     NULL<br>
  care_cats   int(11) No<br>
  lng varchar(20) No<br>
  lat varchar(20) No       </p>
  
  <p>My question is how would i create such a search the im reversing looking up long and lat via a third party search i need to give the distance avalble and show the profiles that match the distance</p>