Help for this page

Select Code to Download


  1. or download this
    SELECT * FROM users WHERE $searchfield <= (
      SELECT MAX($searchfield) FROM users WHERE $searchfield < ?) 
    ORDER BY $searchfield DESC 
    LIMIT 1
    
  2. or download this
    SELECT * FROM users 
    WHERE $searchfield < ? 
    ORDER BY $searchfield DESC 
    LIMIT 1