sending a form to a user based on a profile field

[vbted]

i have a form that i want to send to a user based on input from the form. It nees to match a custom profile field. any help on the query would be great. i'm clueless with sql. -Ted

[sabret00the]

what are your attempts at the code looking like so far?

[vbted]

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

[sabret00the]

that's correct.