custom profile query

[vbted]

That's prob a good idea. thanks

i'm lost, sorry. maybe if i explain it better....

for example; I have a form that is gonna be filled out by the general public, the first input box is called "$normalanswer1". If this info matches one of my users custom field19 I would like the query to return that users id #.

I hope this helps i'm in need of some serious help.

$get_userid = $DB_site->query("SELECT userid
FROM " . TABLE_PREFIX . "user
WHERE " . TABLE_PREFIX . "field19='$normalanswer1'");
$user_id = $DB_site->query($get_userid);

am i close?