problem driving me mad

[Bald Bouncer]

it will need to pull field14 from userfield not users i think....so how exactly do I use join to stick both the coloms in the same query mate?

PHP Code:

$users = $DB_site->query(" 
SELECT userid,username,usertitle
FROM user 
WHERE username LIKE '%".addslashes(htmlspecialchars($findname))."%' 
ORDER BY username 
"); 


I need to grab field14 from userfield in the above :dead: