Help with Code

[Parker Clack]

I am wanting to display a profile field in the user.php file in the admincp directory.

Currently the code to pull the data from the table is

$users = $db->query_read("
		SELECT userid, username,  email, ipaddress
		FROM " . TABLE_PREFIX . "user
		WHERE usergroupid = 4
		ORDER BY username
	");

What would I change this to so it also pulls data from the userfield for that userid?

Thanks.

[amykhar]

$users = $db->query_read("
		SELECT user.userid, user.username,  user.email, user.ipaddress,userfield.*
		FROM " . TABLE_PREFIX . "user as user 
LEFT JOIN ".TABLE_PREFIX."userfield ON user.userid=userfield.userid 
		WHERE usergroupid = 4
		ORDER BY username
	");

That's roughly it. You may need to tinker and adjust syntax. I wrote it cold.

[Parker Clack]

Thanks.

Worked like a charm.

[amykhar]

No problem.