Member Avatar for tanmoy_india

I summarised my problem by a simple example,anyone plzz ans this...then I will be able to understand my problem.......:

Suppose in a database named "DATABASE"..there is a table called "XYZ"..it has 4 rows named "T1,T2,T3,T4"..one primary key named "T_id"..now what I want that to access this same table via different ids from different location but with same primary key..so I have to put some different ids also,so I give "key1_id,key2_id"..so now I have these rows in my table:
"T_id,key1_id,key2_id,T1,T2,T3,T4"

I am giving a screenshot of the table structure:
http://img11.imageshack.us/img11/4717/82031836.jpg


Now what will be the code for (add/edit/del) for these rows..I means how to access this same table via different ids from different location but with same primary key

  • 3 Contributors
  • 8 Replies
  • 83 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by tanmoy_india
Member Avatar for Aamit

post your table structure

Member Avatar for tanmoy_india

I added a screenshot of the table..........what I want is..onetime I access(add/edit.del) all the rows "T1,T2,T3,T4" by the Primary key T_id and key1_id....also separately access(add/edit.del) all the rows "T1,T2,T3,T4" by the Primary key T_id and key2_id............plzz tell the code

Member Avatar for Aamit

post your sample data and what you want to display...
so i can help you to write query

Member Avatar for somedude3488

Can you explain what you are doing (not the table structure)? That way we can make sure the table setup is correct and there is not an easier way.

Member Avatar for Aamit

post your sample data and what you want to display...
so i can help you to write query

please read post correctly...

http://img149.imageshack.us/img149/7929/66701273.jpg

what you want to display...????

is it any category and products data ...using key1_id,key2_id you are differentiate them ??

Member Avatar for tanmoy_india

Can you explain what you are doing (not the table structure)? That way we can make sure the table setup is correct and there is not an easier way.

I know I cant explain properly...So I gave screenshots...i want to add/edit/del in the same 4 tables "T1,T2,T3,T4" from different point via same primary key but different corresponding key value like "key1_id" or "key2_id"

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.