just need the user id

[vbted]

vb3 - I just need a query to give me the users id # based on a custom profile field. I have been trying and searching for about a week now. I'm going to crack!! HELP!! PLEASE. - thanks -Ted

[filburt1]

vb3 - I just need a query to give me the users id # based on a custom profile field. I have been trying and searching for about a week now. I'm going to crack!! HELP!! PLEASE. - thanks -Ted
Set $request like:

$request = addslashes(trim(strtolower("the search string")));

...then the query would be:

SELECT userid FROM userfield WHERE TRIM(LCASE(fieldx)) = "$request";