一对一被关联表 条件限制,帮我看下

#1 fosf

$obj->linker[0]['condition']=‘products_name=ttt';

如上,被关联表 产品名=ttt 的,能执行,但是问题出来了,

主表显示了所有的记录,主表并没有跟着到负表的条件限制走(如,我负表只有3条ttt的结果),负表的条件是有效的,因为产品名=ttt的,记录出来了 ,下面是dump的结果

Array
(
[0] => Array
(
[products_id] => 6
[products_image] => day_111012/YSL-Deeppink-Sneakers-Cow-Hide-Leather5533.jpg
[products_price] => 160.00
[detail] =>
)

[1] => Array
(
[products_id] => 7
[products_image] => day_111012/YSL-Gray-Sneakers-Cow-Hide-Leather3151.jpg
[products_price] => 160
[detail] =>
)

[2] => Array
(
[products_id] => 8
[products_image] => day_111017/1.jpg
[products_price] => 123
[detail] => Array
(
[products_name] => ttt
)

)

[3] => Array
(
[products_id] => 9
[products_image] => day_111017/8.jpg
[products_price] => 123
[detail] =>
)
)


应该能看出来什么问题吧,这种情况我应该怎么处理,谢谢!!!

该贴已经同步到 fosf的微博

2011-10-19 15:53:27

#2 jake

“主表显示了所有的记录”,那么在findAll里面限制就行。

$obj->linker[0]['condition']=‘products_name=ttt';是限制从表的

findAll是限制主表的

2011-10-19 15:54:59