Welcome Guest, Not a member yet? Register   Sign In
(n00b) My first lookup table !
#2

[eluser]Dam1an[/eluser]
Would I be correct is assuming you're using MySQL with the MyISAM engine (default)?
If so, you don't really have much in the way of relational integrity (such as foreign key constraints) and transactions (Atomicity, so it all works, all the tables in a transaction get updated or none)

You might want to look into the InnoDB engine which give you these features, although I've not really used it much myself

And yes, it is called a many to many relationship, commonly annoted as m:n (instead of m:m)

And yes, db->insert is only means for a single table insert at a time, but if you use InnoDB, you can use the transaction support provided in the AR classes


Messages In This Thread
(n00b) My first lookup table ! - by El Forum - 07-07-2009, 05:18 AM
(n00b) My first lookup table ! - by El Forum - 07-07-2009, 05:29 AM
(n00b) My first lookup table ! - by El Forum - 07-07-2009, 05:31 AM
(n00b) My first lookup table ! - by El Forum - 07-07-2009, 07:14 AM
(n00b) My first lookup table ! - by El Forum - 07-07-2009, 07:15 AM
(n00b) My first lookup table ! - by El Forum - 07-07-2009, 07:21 AM
(n00b) My first lookup table ! - by El Forum - 07-07-2009, 07:31 AM
(n00b) My first lookup table ! - by El Forum - 07-07-2009, 08:25 AM
(n00b) My first lookup table ! - by El Forum - 07-07-2009, 09:39 AM
(n00b) My first lookup table ! - by El Forum - 07-07-2009, 10:08 AM
(n00b) My first lookup table ! - by El Forum - 07-07-2009, 10:11 AM
(n00b) My first lookup table ! - by El Forum - 07-27-2009, 07:49 AM



Theme © iAndrew 2016 - Forum software by © MyBB