MySql views output issue

I have a view in MySql which I call with 

return  $this->query("select * from proposed_batch where due_date >='".$from."' and due_date <='".$to."'"); 

in one of my models.

I am getting two arrays per row [r] and [

proposed_batch

], I want to get only one  [

proposed_batch

].

What is the problem?

The MySql view:

CREATE VIEW `kids`.`proposed_batch` AS 

select 

    `r`.`user_id` AS `user_id`,

    `s`.`name` AS `service_name`,

    `r`.`title` AS `title`,

    `r`.`name` AS `reciept_name`,

    `p`.`id` AS `id`,

    `p`.`circulation` AS `circulation`,

    `p`.`bank` AS `bank`,

    `p`.`branch` AS `branch`,

    `p`.`account` AS `account`,

    `p`.`cheqe` AS `cheqe`,

    `p`.`amount` AS `amount`,

    `p`.`name` AS `name`,

    `p`.`created` AS `created`,

    `p`.`service_id` AS `service_id`,

    `p`.`vat` AS `vat`,

    `p`.`sign` AS `sign`,

    `p`.`reciept_id` AS `reciept_id`,

    `p`.`due_date` AS `due_date`,

    `p`.`credit_company` AS `credit_company`,

    `p`.`credit_method` AS `credit_method`,

    `p`.`invoice_id` AS `invoice_id`,

    `p`.`batch` AS `batch`,

    `p`.`noinvoice` AS `noinvoice`

from

    ((`kids`.`reciepts` `r`

    join `kids`.`payments` `p`)

    join `kids`.`services` `s`)

where

    ((`p`.`reciept_id` = `r`.`id`) 

and (`p`.`service_id` = `s`.`id`) 

and isnull(`r`.`canceled`) 

and isnull(`p`.`invoice_id`) 

and (`p`.`noinvoice` = 0))

order by `p`.`reciept_id`,`p`.`due_date`

The result:

Array (     [0] => Array         (             [r] => Array                 (                     [user_id] => 4e475639-fb00-402b-b55c-7fc5e7cdc48c                     [title] => dddd                     [reciept_name] => דוד רינה מרני                 )              [proposed_batch] => Array                 (                     [service_name] => שנת לימוד                     [id] => 46                     [circulation] => cheqe                     [bank] => 1                     [branch] => 23                     [account] => 234                     [cheqe] => 345                     [amount] => 2500.00                     [name] =>                      [created] => 2011-08-24 23:35:54                     [service_id] => 1                     [vat] =>                      [sign] =>                      [reciept_id] => 254                     [due_date] => 2011-09-10                     [credit_company] =>                      [credit_method] =>                      [invoice_id] =>                      [batch] =>                      [noinvoice] => 0                 )          )      [1] => Array         (             [r] => Array                 (                     [user_id] => 4e475639-fb00-402b-b55c-7fc5e7cdc48c                     [title] => dddd                     [reciept_name] => דוד רינה מרני                 )              [proposed_batch] => Array                 (                     [service_name] => שנת לימוד                     [id] => 47                     [circulation] => cheqe                     [bank] => 1                     [branch] => 23                     [account] => 234                     [cheqe] => 346                     [amount] => 2500.00                     [name] =>                      [created] => 2011-08-24 23:35:57                     [service_id] => 1                     [vat] =>                      [sign] =>                      [reciept_id] => 254                     [due_date] => 2011-10-10                     [credit_company] =>                      [credit_method] =>                      [invoice_id] =>                      [batch] =>                      [noinvoice] => 0                 )          )      [2] => Array         (             [r] => Array                 (                     [user_id] => 4e475639-fb00-402b-b55c-7fc5e7cdc48c                     [title] => dddd                     [reciept_name] => דוד רינה מרני                 )              [proposed_batch] => Array                 (                     [service_name] => שנת לימוד                     [id] => 48                     [circulation] => cheqe                     [bank] => 1                     [branch] => 23                     [account] => 234                     [cheqe] => 347                     [amount] => 2500.00                     [name] =>                      [created] => 2011-08-24 23:35:59                     [service_id] => 1                     [vat] =>                      [sign] =>                      [reciept_id] => 254                     [due_date] => 2011-11-10                     [credit_company] =>                      [credit_method] =>                      [invoice_id] =>                      [batch] =>                      [noinvoice] => 0                 )          )  )

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php