Jump to content

Help Setting up a database groups table


ambo

Recommended Posts

I need help setting up a group_id table for admin and regular members and do i need to add a id row in my users table i havent been able to find a tutorial on this anywhere and i eventuall want a admin panel... unless anyone has some premade admin panel templates lol but not sure how to tackle this one..

Link to comment
https://forums.phpfreaks.com/topic/125012-help-setting-up-a-database-groups-table/
Share on other sites

well you could just start with a table for groups with just the the user id and there rank. Then in your query's you could use a join to retrieve the user info from the users table and there rank from the groups table.

 

Or if you plan on having admins, founders, moderators etc then one person could be all of these so  you could then ideally have a table for admins a table for mods etc.

 

Hope this helps you get started

 

im still a little confused i was talking to my friend and he said you would put a row in your users table called group id then that would be a 1 2 3...  then you would create a table called group id and then that would be  row1 would be like admin or something and regular

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.