Not working.

Hmm. did exactly as the tutorial said. Have field Last name. When I enter a last name of user, I keep getting nothing back.

Here is my query. Thanks for any help.

SELECT users.uid AS uid,
SUM(search_index.score * search_total.count) AS score,
profile_values_profile_birthdate.value AS profile_values_profile_birthdate_value,
profile_values_profile_first_name.value AS profile_values_profile_first_name_value,
profile_values_profile_last_name.value AS profile_values_profile_last_name_value
FROM users users
LEFT JOIN search_index search_index ON users.uid = search_index.sid
LEFT JOIN search_total search_total ON search_index.word = search_total.word
LEFT JOIN profile_values profile_values_profile_birthdate ON users.uid = profile_values_profile_birthdate.uid AND profile_values_profile_birthdate.fid = '3'
LEFT JOIN profile_values profile_values_profile_first_name ON users.uid = profile_values_profile_first_name.uid AND profile_values_profile_first_name.fid = '1'
LEFT JOIN profile_values profile_values_profile_last_name ON users.uid = profile_values_profile_last_name.uid AND profile_values_profile_last_name.fid = '2'
WHERE (search_index.word = 'painton') AND (search_index.type = 'users')
GROUP BY search_index.sid, profile_values_profile_last_name_value, uid, profile_values_profile_birthdate_value, profile_values_profile_first_name_value
HAVING COUNT(*) >= 1
ORDER BY profile_values_profile_last_name_value DESC