How do I query a DB Table's field, selected by variable as column name?
We are building this tool where admins can group the range of followers by what has been added in a 'creation' screen.
So they might put Facebook: followers 5000-10000. Twitter: followers 2500-5000.
The users enter their followers into a field, and their social media platform.
So I need the database to query both the platform name and their followers, dynamically.
SELECT u.id, u.selfdescription, u.usertype AS usertype,
u.username AS username, u.firstname AS firstname,
u.su
Normalize your data (as @requinix has just said while I was still typing)
+------------------+ +------------------+ +------------------+ +------------------+
| gigassigned | | user | | user_platform | | platform |
+------------------+ +------------------+ +------------------+ +------------------+
| userid |>-----