Dan Filkovich
New member
I have a table of different widgets lets say the table is (widgetID, widgetName).
I have a list of users and the widgets they have (ID,userID,widgetID)
and a table of user information (ID,username,pass,name,gender, etc...)
I need to get an array of users with a specific gender...
"SELECT FROM users WHERE gender='male'"
Then I need to add up which widgets male's currently have so I need to end up with an array that is like so....
$theArray[widgetID][numOfUsersWithWidget]
What would be the best way to go about this? Basically I'm just trying to output a table of results. So I could easily output a table with the above array. I just am not sure about how to get to that point.
I have a list of users and the widgets they have (ID,userID,widgetID)
and a table of user information (ID,username,pass,name,gender, etc...)
I need to get an array of users with a specific gender...
"SELECT FROM users WHERE gender='male'"
Then I need to add up which widgets male's currently have so I need to end up with an array that is like so....
$theArray[widgetID][numOfUsersWithWidget]
What would be the best way to go about this? Basically I'm just trying to output a table of results. So I could easily output a table with the above array. I just am not sure about how to get to that point.