in reply to Re^6: CGI Action call
in thread CGI Action call
Why use sub selects here
SELECT * FROM users WHERE $searchfield <= ( SELECT MAX($searchfield) FROM users WHERE $searchfield < ?) ORDER BY $searchfield DESC LIMIT 1
instead of the simpler
pojSELECT * FROM users WHERE $searchfield < ? ORDER BY $searchfield DESC LIMIT 1
|
|---|