[mekro]

Hi can you help me with a small error i have it is below:

Invalid SQL: 
		SELECT 
			user.userid,
			usergroupid,
			birthday_search,
			username,
			posts
		FROM 
			vb_user
		LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)			
		WHERE 
			1=1
		ORDER BY 
			RAND()
		LIMIT 
			1
	
mysql error: Unknown table 'user' in field list

mysql error number: 1109

Thanks for any help.

Kirk