three table join in codeigniter

[eluser]astroanu[/eluser]
Its better to keep 2 tables. one for users and another for subusers. and make a reference column from sub users to users.

if you're saving the industry type on to the table filed i recommend convert the types to a comma delimited string. you can use explode to convert it in to an array later on.

hope this helps. if you're looking for a user manager system try this. https://github.com/astroanu/User-managem...odeigniter im still developing it.