Welcome Guest, Not a member yet? Register   Sign In
how do we use multiple tables entry in codeigniter
#4

[eluser]jedd[/eluser]
Quote: i have two tables
one is User_table. it contains user_id (primary,Auto increment) ,User_name and password.
another is profile_table. profile _id(primary,Auto increment) ,user_id ,User_name and password.

Do you really have User_name and password columns replicated in those two tables?

In any case, you have a user.id (either because you've just done an insert, or a select to find the row you want). And then you do an insert or update query on your profile table and put that value in.

I'm unsure where you're getting stuck. Can you post the model code you've got so far for your insert?


Messages In This Thread
how do we use multiple tables entry in codeigniter - by El Forum - 07-29-2009, 06:22 AM
how do we use multiple tables entry in codeigniter - by El Forum - 07-29-2009, 06:47 AM
how do we use multiple tables entry in codeigniter - by El Forum - 07-29-2009, 06:52 AM
how do we use multiple tables entry in codeigniter - by El Forum - 07-29-2009, 07:02 AM
how do we use multiple tables entry in codeigniter - by El Forum - 07-29-2009, 07:08 AM
how do we use multiple tables entry in codeigniter - by El Forum - 07-29-2009, 07:11 AM
how do we use multiple tables entry in codeigniter - by El Forum - 07-29-2009, 08:07 AM
how do we use multiple tables entry in codeigniter - by El Forum - 07-29-2009, 12:09 PM



Theme © iAndrew 2016 - Forum software by © MyBB