Joins with composited prmary keys in PHP Libraries

Joerg.Bernau

Hi,

How can I query a composited prmary key with the PHP Libraries?

SELECT qu. strQuestion, qu.strImageReference FROM tbl_questions AS qu LEFT JOIN tbl_topics AS tp ON tp.idTopics=qu.refIdTopics LEFT JOIN tbl_answers AS aw ON aw.refIdTopics=qu.refIdTopics AND aw.refIdQuestions = qu.idQuestions;

Best Greetings from Lemgo, Germany

Joerg Bernau

allan

I'm afraid there is no support for composite keys with the Editor PHP libraries at the moment. This is a feature I hope to add for Editor 1.6 as it can be really useful.

Allan

Joerg.Bernau

Thanks, allan!