It seems to me the easiest thing to do is delete all the relations for the
account and create all new ones with the data submitted from the form.
This seems wasteful, but the alternative would be a pain. Or is this
really the best way?
I do it the same way.. I'm open to suggestions about better ways to do
it too but *shrug* this works well.
Are you doing this action a lot or is it an occasional thing that will
happen? That is - is it worth investing a lot of time in to finding
another approach?
Completely off topic, (but not worth a separate post) I have been forced
to use a little bit of mysql lately...did you know that if you use
transaction and foreign key syntax with myisam tables, it does not
complain...it just silently ignores your requests for transactions and
foreign key checks. Yikes! I had incorrectly assumed I would get an
error message indicating that transactions are not supported. Oh well.
Well, it's documented.
http://dev.mysql.com/doc/refman/4.1/en/ansi-diff-foreign-keys.html
For storage engines other than InnoDB, MySQL Server parses the FOREIGN
KEY syntax in CREATE TABLE statements, but does not use or store it.
--
Postgresql & php tutorials
http://www.designmagick.com/