[eluser]Unknown[/eluser]
hello again.
i just want to ask for some tips.
so here is the situation.
I have this 7 tables.
table1 is connected to table2 with a foreign key.
also table 2 is connected to table3 by a foreign key and so on... up to table7.
so table1 has this fields.
TABLE1
table1_id
table1_name
table_2 foreign key.
and table 2 has this.
TABLE2
table2_id
table2_name
table_3 foreign key
..and so on.
lets say that table1->table7 has data in it.
basically they are connected.
i just need tips for this.
i want to insert another data to the DB. and i want to minimize retyping everything in the input fields.the data i want to insert is already in the DB and the only difference is the table1 but the table2->table7 is the same. how can i check and get the existing data from the DB.im just getting a bit fuzz in this algo. hope you can give me some tips.