Jump to the post that solved this thread.
Solved: 1 Year ago Use simple_select to get custom profile fields
#6
Solved: 1 Year ago
(2020-09-22, 08:01 PM)OmarĀ G. Wrote:
Quote:Use simple_select to get custom profile fields

$query = $db->simple_select("users u LEFT JOIN {$db->table_prefix}userfields f ON (f.ufid=u.uid)", 'u.*, f.fid4', 'u.usergroup=18', ['order_by' => 'u.username', 'order_dir' => 'asc']);

I never figured it could be possible to use join in simple_select... Next time, I'll look at simple_select() code before answering Smile
Thanks Omar for the tip.
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM or Discord
Reply
Jump to the post that solved this thread.


Messages In This Thread
RE: Use simple_select to get custom profile fields - by Crazycat - 2020-09-22, 09:32 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)