woj56k Posted December 31, 2012 Share Posted December 31, 2012 Hello, I'm not sure if this is in the right area but if it's not please feel free to move it. I'm in the process of creating a game where a user from the users table will be allowed to create and select characters that are binded to that users profile. Allowing users to have up to two characters that can be selected to "Play As" after login in with the user account. My problem is since while I am not extremely new to php, this approach has me a bit stumped. How could I bind characters created by a userid to that userid? Is it something simple that I missed and just am over thinking? For example sake, we'll use 'users' table and 'characters' table. Any help or suggestions? Much appreciated! Quote Link to comment https://forums.phpfreaks.com/topic/272547-user-creates-multiple-characters/ Share on other sites More sharing options...
Muddy_Funster Posted December 31, 2012 Share Posted December 31, 2012 have a userid field in the characters table and use an INNER JOIN to link the tables together. Quote Link to comment https://forums.phpfreaks.com/topic/272547-user-creates-multiple-characters/#findComment-1402369 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.