[binaryg]

PHP Code:

$users= $db->query_first("
                SELECT member AS member
                FROM " . TABLE_PREFIX . "members AS members
                WHERE useridcolumn = " . $useridvariable . " AND fieldcolumn = dataforfield
                LIMIT 1
            "); 


There's probably all sorts of things wrong with that's should get you started... plug whatever info you need in there and see where it takes ya. That's what I do