[RSS Feed/News] How to select data from mysql?

[XenForo]

I have

Brad, boy
Dave, boy

Kathrin, girl
Sabrina, girl


I want to show them in acp like prefixes with prefixe_groups.

Boys

• Brad
• Dave

Girls

• Kathrin
• Sabrina

Should i fetch all names and group them into arrays
1.
fetch data
=> foreach
if group == boy => to array boys
if group == girls=> to array girls

or

2.
fetch data grouped bymysql left_join with data from table goup?
But then i have a lot of not needed data in a row like

Brad, boy...

Read more

ادامه مطلب...