what is different between two queries?

Yii 1.1 General Discussion
1

Hi,

here are two query. second one returning more data… why? what is different between two queries?




$alternative = new CActiveDataProvider('MedicineDrugform', array (

			'criteria' => array (

				'condition'=> 'alternativegroup=' . $alternativegroup,

				'with' => array (

					'drug',

				)

			)

		));

it lists:

ASPİRİN Tablet 100 mg 20 tabletlik blister ambalaj

ASİNPİRİNE Tablet 300 mg 100 tabletlik blister ambalaj

ASPİRİN Tablet 500 mg 20 tabletlik blister ambalaj

ATASPİN Tablet 80 mg 20 tabletlik ambalaj

ASPİNAL Tablet 500 mg 20 tabletlik blister ambalaj

BABYPRİN Tablet 80 mg 20 tabletlik ambalaj

CORASPİN Enterik Tablet 300 mg 30 enterik tabletlik blister ambalaj

DİSPRİL Efervesan Tablet 300 mg 24 efervesan tabletlik ambalaj

ECOPİRİN Enterik Tablet 150 mg 30 enterik tabletlik ambalaj

ECOPİRİN Enterik Tablet 150 mg 20 enterik tabletlik ambalaj

ECOPİRİN Enterik Tablet 300 mg 30 enterik tabletlik ambalaj

ECOPİRİN Enterik Tablet 300 mg 20 enterik tabletlik ambalaj




$alternative = MedicineDrugform::model()->with('drug')->findall(array('condition'=>'alternativegroup=' . $alternativegroup));

it lists:

ASPİRİN Tablet 100 mg 20 tabletlik blister ambalaj

ASİNPİRİNE Tablet 300 mg 100 tabletlik blister ambalaj

ASPİRİN Tablet 500 mg 20 tabletlik blister ambalaj

ATASPİN Tablet 80 mg 20 tabletlik ambalaj

ASPİNAL Tablet 500 mg 20 tabletlik blister ambalaj

BABYPRİN Tablet 80 mg 20 tabletlik ambalaj

CORASPİN Enterik Tablet 300 mg 30 enterik tabletlik blister ambalaj

DİSPRİL Efervesan Tablet 300 mg 24 efervesan tabletlik ambalaj

ECOPİRİN Enterik Tablet 150 mg 30 enterik tabletlik ambalaj

ECOPİRİN Enterik Tablet 150 mg 20 enterik tabletlik ambalaj

ECOPİRİN Enterik Tablet 300 mg 30 enterik tabletlik ambalaj

ECOPİRİN Enterik Tablet 300 mg 20 enterik tabletlik ambalaj

ECOPİRİN Enterik Tablet 500 mg 20 enterik tabletlik ambalaj

NÖTRAS Tablet 450 mg 20 tabletlik ambalaj

PHARMASPİRİN Tablet 300 mg 100 tabletlik ambalaj

ATASPİN Tablet 500 mg 20 tabletlik ambalaj

CORASPİN Enterik Tablet 100 mg 30 enterik tabletlik blister ambalaj

ECOPİRİN Enterik Tablet 100 mg 20 enterik tabletlik ambalaj

ECOPİRİN Enterik Tablet 100 mg 30 enterik tabletlik ambalaj

ALGO-BEBE Tablet 100 mg 20 tabletlik ambalaj

ASİNPİRİNE Tablet 100 mg 100 tabletlik blister ambalaj

ASİNPİRİNE Tablet 500 mg 20 tabletlik blister ambalaj

OPON Tablet 500 mg 20 tabletlik ambalaj

2

does it about pagination?

3

CActiveDataProvider has a default pagination class of type CPaginate and this one has the default value of pageSize to 10 - http://www.yiiframework.com/doc/api/1.1/CPagination#pageSize-detail

4

Thank you mdomba