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

SELECT * FROM users WHERE $searchfield < ? ORDER BY $searchfield DESC LIMIT 1
poj