Jump to content


Photo

Symlink fields in a table?


  • Please log in to reply
1 reply to this topic

#1 tyler

tyler
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 17 September 2003 - 11:25 PM

I have 3 tables,

table1
table2
table3

They all have the same field;

field1
field1
field1

Therefore, when anything gets changed in field1, it needs to update it 3 times. Is there a way to symlink the fields in the other 2 tables so it just looks at table1\'s field1 for the other 2 tables?

Thanks,
-t

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,017 posts

Posted 18 September 2003 - 05:41 PM

That\'s precisely the reason why data should be held in one place and not duplicated across tables. The only things that should be duplicated are (non-changing) key references for joining tables.

What is the structure of your 3 tables?
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users