title: How to count users ahead and behind of a particular user in PHP MYSQL
body: <p>I have a pre-register form. After signup I have to show the current registerar his current position. The current position is determined by counting rows ahead and behind of particular row.</p>
  
  <p>For example, if the signup ID of Jack Smith is 42 I want to show how many user are ahead of him registered and behind him. If the total record is supposed to have 200 enteries.</p>
  
  <p>I am wondering how I can achieve this in MYSQL and PHP.</p>
  
  <p>Thanks in advance!</p>