Lyn, hi
your porblem is that you do not think in sql reality)
you want relation many-to-many
so you have to introduce one more table
and so youll get
1st table: books (id, name)
2nd table: questions (id, q_title, q_data)
3rd table: books_questions (book_id, question,id)
may be 4th table "requestion" , just the same struct. like third
and you have to use have-many-and-belongs-to relation
On Feb 14, 2:46 am, "lynda" <[EMAIL PROTECTED]> wrote:
> Thank you for your reply! Table req_questions is a table to define
> questions, and table books just has the fields questions and
> req_questions to list question_ids in these two fields. Table books
> has other fields like category, articles, sections and segments, I
> didn't include them because I just want to edit questions and
> req_question fields, and delete question_ids in these 2 fields when I
> delete question_id in table questions. I am not allowed to change
> table. At first I was using $hasMany in model Question. For example,
> var $hasMany = array('Book' =>'Book');
> it gave me empty array because it requires these two tables associated
> by a foreign key, question_id is not a foreign key in table books.
> Below are my table look like:
> books
> book_id questions req_questions title
> 1 11, 23, 33 23, 33 This is a
> book
> 2 18, 23, 39 23 This is
> another book
>
> questions
> question_id question_title question_data
> 11 question 11 this is a question
> 18 question 18 this is another questions
> 23 question 23 this is another questions
> 33 question 33 another questions
>
> If I set var primaryKey ='question_id' in Model Question, I think cake
> will recognize $question_id is $id.
> I am not allowed to change the table structures, I am hoping someone
> can help me to find a way to connect fields questions and
> req_questions to question_id.
>
> Thanks!
> Lynda
>
> On Feb 13, 2:42 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>
> > Hi Lynda,
>
> > I think the association you need is a hasMany since book can have many
> > questions. I assume a question is specific to a book, so the question
> > model would have a belongsTo association with book.
>
> > However you have two there pointing to the same table so it's a bit
> > tricky. What is the purpose of the questions and req_questions?
> > Maybe there's another way to achieve the same result? Can you simply
> > put a value (1 or 0) in the questions table to denote whether it's a
> > normal quesiton or req_question?
>
> > Also as an aside, the primary key for "books" and "questions" should
> > be "id" in both cases not "book_id" and "question_id"
> > It took me a while to understand this as well. :-) Cake expects the
> > primary key of every table to be "id" and you can then refer to it
> > from other tables as "modelname_id"
>
> > e.g.
> > You could have a table "notes" to add notes about each book.
> > This table would have a field "book_id" which cake automatically links
> > to the "id" field in "books" if you setup a belongsTo association in
> > the "notes" model and a hasMany association in the "books" model.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
