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]

Originally Posted by 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

Set $request like:

PHP Code:

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

...then the query would be:
[sql]
SELECT userid FROM userfield WHERE TRIM(LCASE(fieldx)) = "$request";
[/sql]