امتیازها
113
راهحلها
27
- محل سکونت
- England
- نوشتهها
- 26,276
- تاریخ ثبتنام
- ۱۳۹۹٫۰۴٫۰۶
- پسندها
- 3,286
- سن
- 29
- وب سایت
- xenforo.xyz
- نسخه PHP
- 7.3
- نسخه زنفورو
- xenforo 2.2
Some thoughts from a beginner about a mysql-query.
Lets say i need some new fields for xf_user.
Which colors do you like?
red, green, blue, yellow, grey, orange
1. I could add now some fields like:
xf_user.red
xf_user.green
xf_user.blue
xf_user.yellow
(or color1, color2, color3)
select * from xf_user where red = 1 AND green=1
but we dont like to have so many new fields here.
2. I could add a textfield
xf_user.colors with value "greenbludyellow"
select * from...
Read more
Lets say i need some new fields for xf_user.
Which colors do you like?
red, green, blue, yellow, grey, orange
1. I could add now some fields like:
xf_user.red
xf_user.green
xf_user.blue
xf_user.yellow
(or color1, color2, color3)
select * from xf_user where red = 1 AND green=1
but we dont like to have so many new fields here.
2. I could add a textfield
xf_user.colors with value "greenbludyellow"
select * from...
Read more
