我在这里做错了什么?
$sub_data = $this->Subscriber->find('all', array(
'joins' => array(
'table' => 'subtypes',
'alias' => 'Subtype',
'type' => 'LEFT',
'conditions' => array(
'Subtype.id = Subscriber.plan',
)
),
'conditions' => array(
'Subscriber.plan' => $plan['Subtype']['id'],
'Subscriber.authcode !=' => '',
'Subscriber.subended' => '0000-00-00 00:00:00',
'Subtype.authorize_trial_only' => '1',
)
));
最终语句以某种方式无法正确生成。那就是我得到一个SQL错误的部分:
...从
subscribers
AS Subscriber
子类型子类型LEFT数组WHERE
Subscriber
。plan
='10'并且Subscriber
。authcode
!=''并且Subscriber
。subended
='0000-00-0000:00:00'AND
Subtype
。authorize_trial_only
='1'与...
最佳答案
应该是
'conditions' => array(
'Subtype.id' => 'Subscriber.plan',
)
还是我只是疯了?
编辑:
您可能需要在其中添加另一个级别的array()吗?即
'joins' => array( array ( 'table' => ...
关于mysql - 连接和CakePHP错误,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/5556554/